You can then restart the job using start_job:
Export> START_JOB
You can specify a log file location for the export log file via the LOGFILE parameter. If you do
not specify a value for LOGFILE, the log file will be written to the same directory as the dump file.
Exporting from Another Database
You can use the NETWORK_LINK parameter to export data from a different database. If you are
logged into the HQ database and you have a database link to the DW database, Data Pump can
use that link to connect to the DW database and extract its data.
NOTE
If the source database is read-only, the user on the source database
must have a locally managed tablespace assigned as the temporary
tablespace; otherwise, the job will fail.
In your parameter file or on the expdp command line, set the NETWORK_LINK parameter
to the name of the database link. The Data Pump Export job will write the data from the remote
database to the directory defined in your local database.
Using EXCLUDE, INCLUDE, and QUERY
You can exclude or include sets of tables from the Data Pump Export via the EXCLUDE and
INCLUDE options. You can exclude objects by type and by name. If an object is excluded,
all its dependent objects are also excluded. The format for the EXCLUDE option is
EXCLUDE=object_type[:name_clause] [, ...]
402 Oracle Database 11g DBA Handbook
NOTE
You cannot specify EXCLUDE if you specify CONTENT=DATA_ONLY.
For example, to exclude the MARTHAG schema from a full export, the format of the
EXCLUDE option is as follows:
EXCLUDE=SCHEMA:"='MARTHAG'"
NOTE
You can specify more than one EXCLUDE option within the same
Data Pump Export job.
Pages:
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626