-
impdp error
Anybody have a clue as what the error below means on the an impdp
Copyright (c) 2003, 2007, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "ORACLE"."SYS_IMPORT_FULL_04" successfully loaded/unloaded
Starting "ORACLE"."SYS_IMPORT_FULL_04": /******** directory=dsp dumpfile=mtas_2
0101021.dmp
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31696: unable to export/import TABLE_DATA:"MTAS"."MTAS_HISTORY":"HISTORY_201
01021" using client specified AUTOMATIC method
I exported the following partitions from a table here is my parfile.
directory=DATA_PUMP
dumpfile=mtas_20101021.dmp
logfile=mtas_20101021.log
content=DATA_ONLY
tables=MTAS.MTAS_HISTORY:HISTORY_20101021,MTAS.MTAS_REQ:REQ_20101021,MTAS.MTAS_RESULT:RESULT_2010102 1
During the import, the exact partitions names exist on the target and the tables are the same.
Here is my import command
impdp / directory=dsp dumpfile=mtas_20101021.dmp TABLE_EXISTS_ACTION=APPEND
-
is all the partitions / sub-partitions exists in target? Is the table space names are same in both the data bases?
Thanks,
-
It took alot of digging but I found the problem, one of the indexes was marked 'UNUSABLE'. I rebuilt the index and the import worked.
-
Thanks for sharing Paul.
Thanks,
-
NP I am all for sharing the knowledge