| Team Fly | |
NETWORK_LINK allows an import into a target database directly from a source database rather than from a dump file.
PARALLEL is a performance option that can be used to specify the maximum number of threads that can be used to speed up an export by running it in parallel.
PARFILE can be included to point to another file that includes export parameters. Use this when filtering data and metadata using the exclude, include, or query parameters.
QUERY can be used to apply syntax similar to qualifiers that you would use in a select...where clause to filter the rows to be exported.
TRANSPORT_TABLESPACES (TTS) is the parameter used to specify the tablespaces that will have their metadata exported during a transportable tablespace operation. When this is done, the tablespaces in the source database should be placed in read-only mode and their underlying datafiles copied to a new location. The datafile copies are performed at the OS level. The only ''export" is that of the metadata. The datafile copies and exported metadata can be used to plug in the tablespaces to a target database. The tablespaces must be a self-contained set and the transport_full_check parameter can be used to ensure this is the case.
ADD_FILE is valuable if an export operation fills the current dump file. When this occurs, you will be prompted to add a new dump file and you are able to do so.
START_JOB allows you to start a job to which you are attached. This allows you to restart an export after a previous failure and is valuable for long-running jobs.
Examples that use some of these appear in the next section.
To perform a full database export using data pump, run the following:
expdp system/manager DUMPFILE=expdat.dmp FULL=y LOGFILE=export.log
A Schema Level Export of the Sales History (SH) schema can be performed as follows:
expdp system/manager DUMPFILE=expdat.dmp SCHEMAS=sh LOGFILE=export.log
A single table can be exported, as shown next with the sh.customers table:
expdp system/manager DUMPFILE=expdat.dmp TABLES=sh.customers LOGFILE=export.log
| Team Fly | |