Home > Administration > Re-attach impdp job procedure

Re-attach impdp job procedure

1. Query datadump jobs

SQL>  select owner_name, state , JOB_NAME from DBA_DATAPUMP_JOBS ;

OWNER_NAME                     STATE                          JOB_NAME
—————————— —————————— ——————————
VI                             EXECUTING                      SYS_IMPORT_FULL_01
SYSTEM                         NOT RUNNING                    SYS_EXPORT_SCHEMA_01

2. Attach the job SYS_IMPORT_FULL_01

$ impdp vi/vi attach=SYS_IMPORT_FULL_01

Import: Release 10.2.0.3.0 – 64bit Production on Wednesday, 03 February, 2010 16:44:24

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production
With the Partitioning, OLAP and Data Mining options

Job: SYS_IMPORT_FULL_01
Owner: VI
Operation: IMPORT
Creator Privs: FALSE
GUID: 7EAE2EB32B690359E0440000779B8480
Start Time: Wednesday, 03 February, 2010 15:29:44
Mode: FULL
Instance: viqa
Max Parallelism: 4
EXPORT Job Parameters:
CLIENT_COMMAND        vi/******** parfile=exp_vi_tab.par
IMPORT Job Parameters:
Parameter Name      Parameter Value:
CLIENT_COMMAND        vi/******** parfile= imp_vi_tab.par
TABLE_EXISTS_ACTION   REPLACE
State: EXECUTING
Bytes Processed: 53,157,093,984
Percent Done: 99
Current Parallelism: 4
Job Error Count: 0
Dump File: /rcdb/oracle/bkup/dmp/VIM_TAB_2Geb2010.dmp

Worker 1 Status:
State: EXECUTING
Object Schema: VI
Object Name: PK_CP
Object Type: TABLE_EXPORT/TABLE/INDEX/INDEX
Worker Parallelism: 4

Worker 2 Status:
State: WORK WAITING

Worker 3 Status:
State: WORK WAITING

Worker 4 Status:
State: WORK WAITING

Advertisements
Categories: Administration
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: