Shulou(Shulou.com)06/02 Report--

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: >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.