Copies the Oracle CDD/Repository data dictionary definition of one or more dictionary objects or types of object definitions to a command file. Format { {DOMAINS } } { {PLOTS } } { [ALL] {PROCEDURES } [,...] [ON] file-spec } { { } } { {RECORDS } } { {TABLES } } EXTRACT { } { ALL [ON] file-spec } { } { } { [ON] file-spec path-name [,...] } { } { } { path-name [,...] [ON] file-spec }
1 – Arguments
ALL Causes DEC DATATRIEVE to copy into the specified command file the definitions of one or more dictionary objects in your default dictionary directory. The keyword ALL is optional when used with the types of object definitions such as PLOTS or DOMAINS. The keyword ALL is required, however, when used with the EXTRACT ALL [ON] file-spec syntax. DOMAINS Allows you to extract all the domains, plots, procedures, records, or tables from your current default Oracle CDD/Repository directory. file-spec Is the OpenVMS specification of the RMS file to contain the definitions. A complete file specification has the following format: node-spec::device:[directory]file-name.type;version path-name Is the given name, full dictionary path name, or relative path name of the dictionary object whose definition you want to copy. If you specify more than one dictionary path name, use a comma to separate each one from the next. EXTRACT accepts both DMU and CDO style path names.
2 – Example
Extract all the definitions in a dictionary directory to create a backup file: DTR> EXTRACT ALL ON BAKUP1 DTR>