TRANSPORTABLE Exports metadata only for a table mode export.
VERSION Specifies the version of database objects to be created so
the dump file set may be compatible with earlier releases of
Oracle. The options are COMPATIBLE, LATEST, and database
version numbers (not lower than 9.2).
TABLE 11-1 Command-Line Input Parameters for expdp (continued)
Chapter 11: Backup and Recovery Options 399
Starting a Data Pump Export Job
You can store your job parameters in a parameter file, referenced via the PARFILE parameter of
expdp. For example, you can create a file named dp_rjb.par with the following entries:
directory=dpxfer
dumpfile=metadata_only.dmp
content=metadata_only
The logical data pump directory is DPXFER, the one I created earlier in the chapter. The data
pump export will only have metadata; the name of the dump file, metadata_only.dmp, reflects the
contents of the dump file. Here??™s how you initiate a data pump job using this parameter file:
expdp rjb/rjb parfile=dp_rjb.par
Oracle will then pass the dp_rjb.par entries to the Data Pump Export job. A schema-type Data
Pump Export (which is the default) will be executed, and the output (metadata only, no table
rows) will be written to a file in the DPXFER directory. Here is the output from the expdp
command:
[oracle@dw ~]$ expdp rjb/rjb parfile=dp_rjb.par
Export: Release 11.1.0.6.0 - Production on Saturday, 25 August, 2007 9:45:57
Copyright (c) 2003, 2007, Oracle.
Pages:
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622