oracle impdp job,Impdp and Expdp example02 job control

2)expdp / impdp example02 job

1@@@@Monitoring and Control job

When these tools are running in normal noninteractive mode, you can move into

interactive mode by typing Control-C

In interactive mode, the commands that we can issue are:

~ADD_FILE to add a new dump file for the export

~KILL_JOB to delete the job

~STOP_JOB, which will suspend the processing of our job and exit back to the

operating system.

~PARALLEL to alter the degree of parallelism

After you STOP_JOB, you could continue using ATTACH and JOB_NAME=expfull. If only

one job is running, you could ignore the JOB_NAME.

@@@

@@@<1>create directory for expdp and impdp.

@@@

SYS@ocp> GRANT read,write ON DIRECTORY data_file_dir TO sh;

Grant succeeded.

@@@

@@@<2>control the job process and inspect the report of job.

@@@

[oracle@station78 ~]$ expdp USERID=sh/sh@ocp FULL=y DIRECTORY=data_file_dir \

> DUMPFILE=full_dump_sh.dat JOB_NAME=expfull;

Export: Release 10.2.0.1.0 - 64bit Production on Friday, 24 August, 2012 14:16:02

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

FLASHBACK automatically enabled to preserve database integrity.

Starting "SH"."EXPFULL":  USERID=sh/********@ocp FULL=y DIRECTORY=data_file_dir DUMPFILE=full_dump_sh.dat JOB_NAME=expfull

Estimate in progress using BLOCKS method...

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

Export> stop_job=immediate

Are you sure you wish to stop this job ([yes]/no): yes

[oracle@station78 ~]$ expdp sh/sh@ocp ATTACH=expfull     @@@<==assign the job name to interactive mode.

Export: Release 10.2.0.1.0 - 64bit Production on Friday, 24 August, 2012 14:16:54

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

Job: EXPFULL      @@@<==report the job status automatically.

Owner: SH

Operation: EXPORT

Creator Privs: FALSE

GUID: C7FDE96034E6A140E040A8C04E001653

Start Time: Friday, 24 August, 2012 14:16:57

Mode: FULL

Instance: ocp

Max Parallelism: 1

EXPORT Job Parameters:

Parameter Name      Parameter Value:

CLIENT_COMMAND        USERID=sh/********@ocp FULL=y DIRECTORY=data_file_dir DUMPFILE=full_dump_sh.dat JOB_NAME=expfull

State: IDLING

Bytes Processed: 0

Current Parallelism: 1

Job Error Count: 0

Dump File: /home/oracle/datafiles/full_dump_sh.dat

bytes written: 4,096

Worker 1 Status:

State: UNDEFINED

Object Type: DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT

Completed Objects: 7

Total Objects: 7

Worker Parallelism: 1

Export> continue_client   @@@<==continue the job to noninteractive mode.

...

...

...

. . exported "SYSTEM"."REPCAT$_USER_PARM_VALUES"             0 KB       0 rows

. . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE"              0 KB       0 rows

. . exported "TSMSYS"."SRS$"                                 0 KB       0 rows

Master table "SH"."EXPFULL" successfully loaded/unloaded

******************************************************************************

Dump file set for SH.EXPFULL is:

/home/oracle/datafiles/full_dump_sh.dat

Job "SH"."EXPFULL" completed with 1 error(s) at 14:20:05