Oracle Network Link Parameter

Oracle Tips by Burleson Consulting

This is an excerpt from "Oracle 10g New Features for Administrators" by Ahmed Baraka.

NETWORK_LINK - You can initiate an export job from your server and have Data Pump export data from a remote database to dump files located on the instance from which you initiate the Data Pump export job.

expdp hr/hr DIRECTORY=dpump_dir1
NETWORK_LINK=source_database_link
DUMPFILE=network_export.dmp

Interactive Mode Export Parameters

You can enter the interactive mode of Data Pump export in either of two ways:

o To get into the interactive mode, press Ctl+C while the job is running.

o You can also enter the interactive mode of operation by using the ATTACH command.

expdp salapati/sammyy1
attach=SALAPATI.SYS_EXPORT_SCHEMA_01

You must be a DBA, or must have EXP_FULL_DATABASE or IMP_FULL_DATABASE roles, in order to attach and control Data Pump jobs of other users.

CONTINUE_CLIENT (interactive parameter) - This parameter will take you out of the interactive mode. Your client connection will still be intact, and you�ll continue to see the export messages on your screen.

EXIT_CLIENT (interactive parameter) - This parameter will stop the interactive session, as well as terminate the client session.

STOP_JOB (interactive parameter) - This parameter stops running Data Pump jobs.

START_JOB (interactive parameter) - This parameter resumes stopped jobs. You can restart any job that is stopped, whether it�s stopped because you issued a STOP_JOB command or due to a system crash, as long as you have access to the master table and an uncorrupted dump file set.

KILL_JOB (interactive parameter) - This parameter kills both the client and the Data Pump.

If a job is killed using the KILL_JOB interactive command, the master table is dropped and the job cannot be restarted.

ADD_FILE (interactive parameter) - Use this parameter to add a dump file to your job.

expdp> ADD_FILE=hr2.dmp, dpump_dir2:hr3.dmp

HELP (can be used in interactive mode) - Displays online help.

STATUS (can be used in interactive mode) - This parameter displays detailed status of the job, along with a description of the current operation. An estimated completion percentage for the job is also returned.

In logging mode, you can assign an integer value (n) to this parameter. In this case, job status is displayed on screen every n second.

JOBNAME - Use this parameter to provide your own job name for a given Data Pump export/import job. If not provided, Oracle will give it a name of the format
<USER>_<OPERATION>_<MODE>_%N.

Example: SYSTEM_EXPORT_FULL_01

PARALLEL - This parameter lets you specify more than a single active execution thread for your export job. You should specify number of dump files equal to the PARALLEL value.

expdp system/manager full=y
parallel=4
dumpfile=
DIR1:full1%U.dat,
DIR2:full2%U.dat,
DIR3:full3%U.dat,
DIR4:full4%U.dat
filesize = 2G
impdp system/manager
directory = MYDIR
parallel = 4
dumpfile = full1%U.dat,full2%U.dat,
full3%U.dat,full4%U.dat