SQL>
Data Pump Export Options
Oracle provides a utility called expdp that serves as the interface to Data Pump. If you have
previous experience with the Export utility, some of the options will be familiar. However, some
significant features are available only via Data Pump. Table 11-1 shows the command-line input
parameters for expdp when a job is created.
As detailed in Table 11-1, five modes of Data Pump exports are supported:
Full Export all database data and metadata
Schema Export data and metadata for specific user schemas
Tablespace Export data and metadata for tablespaces
Table Export data and metadata for tables and table partitions
Transportable Tablespace Export metadata for specific tablespaces in preparation for
transporting a tablespace from one database to another
?–
?–
?–
?–
?–
Chapter 11: Backup and Recovery Options 397
Parameter Description
ATTACH Connects a client session to a currently running Data Pump
Export job.
COMPRESS Specifies which data to compress: ALL, DATA_ONLY,
METADATA_ONLY, NONE.
CONTENT Filters what is exported: DATA_ONLY, METADATA_ONLY,
or ALL.
DATA_OPTIONS If set to XML_CLOBS, then XMLType columns are exported
uncompressed.
DIRECTORY Specifies the destination directory for the log file and the
dump file set.
DUMPFILE Specifies the names and directories for dump files.
ENCRYPTION Encryption level of the output: ALL, DATA_ONLY,
ENCRYPTED_COLUMNS_ONLY, METADATA_ONLY, NONE.
Pages:
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619