First, here is a "failed" Data Pump Import that I'd like to "resume":
]$ impdp "'/ as sysdba'" dumpfile=mySchema%U.dmp directory=DATA_PUMP_DIR logfile=Import.log schemas=MYSCHEMA parallel=2
Import: Release 10.2.0.3.0 - 64bit Production on Tuesday, 16 February, 2010 14:35:15
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, Real Application Clusters, OLAP and Data Mining options
Master table "SYS"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_SCHEMA_01": '/******** AS SYSDBA' dumpfile=mySchema%U.dmp directory=DATA_PUMP_DIR logfile=Import.log schemas=MYSCHEMA parallel=2
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "MYSCHE...
...
... 0 KB 0 rows
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [INDEX:"MYSCHEMA"."OBJECT_RELATION_I2"]
SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, grantor, object_row, object_schema, object_long_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, property, size_estimate, in_progress FROM "SYS"."SYS_IMPORT_SCHEMA_01" WHERE process_order between :3 AND :4 AND processing_state <> :5 AND duplicate = 0 ORDER BY process_order
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.KUPW$WORKER", line 12280
ORA-12801: error signaled in parallel query server P001, instance pace2.capitolindemnity.com:bondacc2 (2)
ORA-30032: the suspended (resumable) statement has timed out
ORA-01652: unable to extend temp segment by 128 in tablespace OBJECT_INDX
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6272
----- PL/SQL Call Stack -----
object line object
handle number name
0x1f9ac8d50 14916 package body SYS.KUPW$WORKER
0x1f9ac8d50 6293 package body SYS.KUPW$WORKER
0x1f9ac8d50 3511 package body SYS.KUPW$WORKER
0x1f9ac8d50 6882 package body SYS.KUPW$WORKER
0x1f9ac8d50 1259 package body SYS.KUPW$WORKER
0x1f8431598 2 anonymous block
Job "SYS"."SYS_IMPORT_SCHEMA_01" stopped due to fatal error at 23:05:45
As you can see this job failed without processing statistics, constraints, PL/SQL etc. What I would like to do is issue another impdp command but skip the objects that were successfully imported as noted above. Is there a way to do this (using the EXCLUDE parameter perhaps?) with impdp? If so, what would it be?
Thanks,
John