Experience of Oracle 10g expdp attach parameters
The attractive features and features of expdp are no longer wordy. Today, we mainly test the use of attach parameters.
Simulate the scene:
1) start an expdp job
2) abnormal cancellation
3) connect using attach and continue to execute job
First, start an expdp job
Job_name:pump_test_job
The default name of job_name is: SYS_EXPORT_SCHEMA_01
E: > expdp study/study dumpfile=study.dmp schemas=study job_name=pump_test_job
Export: Release 10.2.0.1.0-Production on Saturday, December, 2007 10:38:19
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options
Start "STUDY". "PUMP_TEST_JOB": study/* dumpfile=study.dmp schemas=study j
Ob_name=pump_test_job
Estimation is being made using the BLOCKS method.
Dealing with object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimate using the BLOCKS method: 49.75 MB
Dealing with object type SCHEMA_EXPORT/USER
Dealing with object type SCHEMA_EXPORT/SYSTEM_GRANT
Dealing with object type SCHEMA_EXPORT/ROLE_GRANT
Dealing with object type SCHEMA_EXPORT/DEFAULT_ROLE
Dealing with object type SCHEMA_EXPORT/TABLESPACE_QUOTA
^ C
E: >
Ctrl+C is executed here twice in a row to simulate the abnormal stop of job tasks.
2. Check the status of expdp job
SQL > select job_name,operation,job_mode,state from user_datapump_jobs
JOB_NAME OPERATION JOB_MODE STATE
-
SYS_EXPORT_SCHEMA_01 EXPORT SCHEMA NOT RUNNING
PUMP_TEST_JOB EXPORT SCHEMA NOT RUNNING
SQL >
Use attach to reconnect to pump_test_job and continue job task
E: > expdp study/study attach=pump_test_job
Export: Release 10.2.0.1.0-Production on Saturday, December, 2007 10:41:34
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options
Job: PUMP_TEST_JOB
Owner: STUDY
Operation: EXPORT
Creator permission: FALSE
GUID: FBBD77FEAA4E4B7B85CB3AC1CB96126F
Start time: Saturday, December, 2007 10:38:59
Mode: SCHEMA
Example: ora10
Maximum parallelism: 1
EXPORT job parameters:
Parameter name parameter value:
CLIENT_COMMAND study/* dumpfile=study.dmp schemas=study job_n
Ame=pump_test_job
Status: EXECUTING
Bytes processed: 0
Current parallelism: 1
Job error count: 0
Dump file: E:ORACLE10GADMINORA10DPDUMPSTUDY.DMP
Bytes written: 4096
Worker 1 status:
Status: EXECUTING
Object type: SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Number of objects completed: 4
Worker parallelism: 1
Export > status
Job: PUMP_TEST_JOB
Operation: EXPORT
Mode: SCHEMA
Status: EXECUTING
Bytes processed: 0
Current parallelism: 1
Job error count: 0
Dump file: E:ORACLE10GADMINORA10DPDUMPSTUDY.DMP
Bytes written: 212992
Worker 1 status:
Status: EXECUTING
Object scheme: STUDY
Object name: TOMS
Object type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Number of objects completed: 1
Total number of objects: 24
Worker parallelism: 1
Export > continue_client
Dealing with object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Dealing with object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Dealing with object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Dealing with object type SCHEMA_EXPORT/TABLE/COMMENT
Dealing with object type SCHEMA_EXPORT/TABLE/RLS_POLICY
Dealing with object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Dealing with object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Dealing with object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Dealing with object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SP
EC
Dealing with object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Dealing with object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Dealing with object type SCHEMA_EXPORT/VIEW/VIEW
Dealing with object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Dealing with object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . Derived "STUDY". "TOMS" 37.63 MB 403816 lines
. . Exported "STUDY". "TOMS_LOG" 831.9 KB 50422 lines
. . Exported "STUDY". "PHOTO" 326.7 KB 1 line
. . Exported "STUDY". "SYS_EXPORT_SCHEMA_01" 115.6 KB 1064 lines
. . Exported "STUDY". "DICT_ITEM" 6.687 KB 13 lines
. . Exported "STUDY". "HASH_DEMO": "SYS_P81" 5.273 KB 1 line
. . Exported "STUDY". "HASH_DEMO": "SYS_P82" 5.289 KB 3 lines
. . Exported "STUDY". "T" 5.632 KB 10 lines
. . Exported "STUDY". "T20" 5.664 KB 1 line
. . Exported "STUDY". "TEST" 5.046 KB 18 lines
. . Exported "STUDY". "TOMS_PART": "pendant 200" 5.585 KB 1 line
. . Exported "STUDY". "TOMS_PART": "pendant 300" 5.585 KB 1 line
. . Derived "STUDY". "TOMS_PART": "P_MAX" 5.601 KB 2 lines
. . Exported "STUDY". "TOMS_REGION_DEF" 7.609 KB 18 lines
. . Exported "STUDY". "TOMS_SEG" 5.695 KB 3 lines
. . Exported "STUDY". "TOMS_STD_TEST" 5.046 KB 17 lines
. . Exported "STUDY". "TOMS_TEST_MID" 5.257 KB 1 line
. . Exported "STUDY". "TOMS_PART": "pendant 100" 0 KB 0 line
. . The line "STUDY". "TOMS_SOURCE_SQL" 0 KB 0 is exported
. . The line "STUDY". "TOMS_SQL" 0 KB 0 is exported
. . The line "STUDY". "TOMS_TABLES" 0 KB 0 is exported
. . The line "STUDY". "TOMS_TAB_COLUMNS" 0 KB 0 is exported
. . Exported "STUDY". "TOMS_TEST": "P1" 0 KB 0 line
. . Derived "STUDY". "TOMS_TEST": "P2" 0 KB 0 line
The primary table "STUDY". "PUMP_TEST_JOB" has been successfully loaded / unloaded
*
The dump file set for STUDY.PUMP_TEST_JOB is:
E:ORACLE10GADMINORA10DPDUMPSTUDY.DMP
Assignment "STUDY". "PUMP_TEST_JOB" completed successfully at 10:43:25
E: >
