You can also apply these filters
during a subsequent Data Pump Import job, as described in the next section.
Data Pump Import Options
To import a dump file exported via Data Pump Export, use Data Pump Import. As with the export
process, the import process runs as a server-based job you can manage as it executes. You can
interact with Data Pump Import via the command-line interface, a parameter file, and an
interactive interface. Table 11-3 lists the parameters for the command-line interface.
As with Data Pump Export, five modes are supported in Data Pump Import:
Full Import all database data and metadata.
Schema Import data and metadata for specific user schemas.
Tablespace Import data and metadata for tablespaces.
Table Import data and metadata for tables and table partitions.
Transportable Tablespace Import metadata for specific tablespaces in preparation for
transporting a tablespace from the source database.
If no mode is specified, Data Pump Import attempts to load the entire dump file.
?–
?–
?–
?–
?–
404 Oracle Database 11g DBA Handbook
Parameter Description
ATTACH Attaches the client to a server session and places you in interactive mode.
CONTENT Filters what is imported: ALL, DATA_ONLY, or METADATA_ONLY.
DATA_OPTIONS Specifies how to handle certain exceptions. As of Oracle Database 11g, the
only valid option is SKIP_CONSTRAINT_ERRORS.
DIRECTORY Specifies the location of the dump file set and the destination directory for the
log and SQL files.
Pages:
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629