-
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
NP I am all for sharing the knowledge
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|