Hi There,
We have 2 big tables that we want to move from one database to another.
We did an expdp so export the tables - everything went ok, but when we try to import the tables in the new database we're getting the following:
C:\oracle\>impdp system/xxx parfile=mig_tables.par
Import: Release 11.1.0.7.0 - 64bit Production on Wednesday, 21 April, 2010 18:40:38
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Release 11.1.0.7.0 - 64bit Production
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/******** parfile=imp_mig.par
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "PROD"."PRODUCTDESC_AUDIT" failed to load/unload and is being skipped due to error:
ORA-31603: object "PRODUCTDESC_AUDIT" of type TABLE not found in schema "PROD"
ORA-31693: Table data object "PROD"."ENTITY_AUDIT" failed to load/unload and is being skipped due to error:
ORA-31603: object "ENTITY_AUDIT" of type TABLE not found in schema "PROD"
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 2 error(s) at 18:40:40
Here is the par file:
DUMPFILE=mig.dmp
LOGFILE=mig.log
TABLES=PRODUCTDESC_AUDIT,ENTITY_AUDIT
REMAP_SCHEMA=PE_SCHEMA:PROD
REMAP_TABLESPACE=PE_TABLES:MIGRATION,PE_AUDIT_TABLES:MIGRATION
CONTENT=DATA_ONLY
Not sure why is this happening!! THe error says that these 2 objects do not exist in the PROD schema which is correct!! that's the whole point behind the import! we are importing them into PROD schema!!
any idea please
Thanks