Use ctrl + c to exit the current status output mode. Run the following command: expdp userid/password attach = job_name to connect to the currently running import/export task. You can use job_name to specify the task name.
1. add_file = test _ % U. pmp append the dump file
2. continue_client exits the interactive mode and enters the log mode.
3. The exit_client exits the interactive mode and enters the operating system command line. The task is converted to running in the background.
4. filesize = 1G specify the size of the dump file generated
5. help list supported Command help information
6. kill_job interrupts the ongoing task
7. parallel = 4 increase the degree of Parallelism
8. stop_job: stop the current task.
9. start_job start the stopped task
10. View task status information
First, execute a full-Database Export task.
- [Oracle @ linux exp] $ ll
- Total 0
- [Oracle @ linux exp] $ expdp system/oracle @ orcl directory = expFull= Y job_name = expfull-- The Task Name is specified here.
- Export: Release 10.2.0.4.0-ProductionOnWednesday, October, 2011 19:09:08
- Copyright (c) 2003,200 7, Oracle.AllRights reserved.
- Connect to: OracleDatabase10g Enterprise Edition Release 10.2.0.4.0-Production
- WithThe Partitioning, OLAP, Data MiningAnd RealApplication Testing options
- Start"SYSTEM"."EXPFULL": System/********* @ orcl directory = expFull= Y job_name = expfull
- Using the BLOCKS Method for estimation...
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
- -- Exit the current state output mode by pressing ctrl + c.
- Export> status-- View the status of a task.
- Job: EXPFULL
- Operation: EXPORT
- Mode:FULL
- Status: EXECUTING
- Bytes processed: 0
- Current degree of Parallelism: 1
- Job error count: 0
- Dump File:/u01/exp/expdat. dmp
- Written Bytes: 4,096
- Worker 1 status:
- Status: EXECUTING
- Export> stop_job-- Stop a task
- Are you sure you want to stop this job ([Y]/N): yes
- [Oracle @ linux exp] $ ll
- Total 120
- -Rw-r----- 1 oracle oinstall 114688 10-05 expdat. dmp
- -Rw-r-- R -- 1 oracle oinstall 1551 10-05 export. log
You can view the table created by the Export task in the database.
- SQL> showUser
- USERIs"SYSTEM"
- SQL>Select*FromTabWhereTname ='Expfull';
- TNAME TABTYPE CLUSTERID
- -----------------------------------------------
- EXPFULLTABLE
Connect to the stopped task again
- [Oracle @ linux exp] $ expdp system/oracle @ orcl attach = expfull-- Connect to the stopped user.
- Export: Release 10.2.0.4.0-ProductionOnWednesday, October, 2011 19:13:14
- Copyright (c) 2003,200 7, Oracle.AllRights reserved.
- Connect to: OracleDatabase10g Enterprise Edition Release 10.2.0.4.0-Production
- WithThe Partitioning, OLAP, Data MiningAnd RealApplication Testing options
- Job: EXPFULL
- Owner: SYSTEM
- Operation: EXPORT
- Creator permission:FALSE
- GUID: AE8C3CC6E83C634BE040007F010011B4
- Start Time: Wednesday, October, 2011 19:13:15
- Mode:FULL
- Instance: orcl
- Maximum degree of Parallelism: 1
- EXPORT job parameters:
- Parameter value:
- CLIENT_COMMAND system/******** @ orcl directory = expFull= Y job_name = expfull
- Status: IDLING
- Bytes processed: 0
- Current degree of Parallelism: 1
- Job error count: 0
- Dump File:/u01/exp/expdat. dmp
- Written Bytes: 114,688
- Worker 1 status:
- Status: UNDEFINED
- Export> start_job-- Start the task.
- Export> continue_client-- Exit interactive mode and enter log mode.
- The job EXPFULL has been re-opened at, January 26, October, 2011, on Wednesday.
- Restart"SYSTEM"."EXPFULL": System/********* @ orcl directory = expFull= Y job_name = expfull
- Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
- ......
- ......
- ......
- .. Exported"SYSTEM"."SYS_EXPORT_FULL_01"13.20 MB 8951 rows
- The master table is successfully loaded/uninstalled."SYSTEM"."EXPFULL"
- **************************************** **************************************
- The dump file set of SYSTEM. EXPFULL2 is:
- /U01/exp/expdat. dmp
- Job"SYSTEM"."EXPFULL"Completed, but there are 2 errors (completed at 19:17:38)