impdp error

[PaulH]

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

[vnktummala]

is all the partitions / sub-partitions exists in target? Is the table space names are same in both the data bases?

Thanks,

[PaulH]

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.

[vnktummala]

Thanks for sharing Paul.

Thanks,

[PaulH]

NP I am all for sharing the knowledge