This content has been marked as final. Show 8 replies
Please help me to overcome this issue.
your export and your import refer to different objects?
If you want to remap your schema you must use the remap funtion from impdp.
I have also tried with RMAP SCEMA option but getting different error this time.
Command used:impdp system TABLES=EXP_SB_HEADER_TMP DIRECTORY=RMS_DATA_PUMP DUMPFILE=EXP_SB_HEADER_TMP.dmp LOGFILE=EXP_SB_HEADER_TMP_impdp.log REMAP_SCHEMA=sss_exp_test:sss_exp
Import: Release 10.2.0.5.0 - 64bit Production on Sunday, 14 October, 2012 21:06:30
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31655: no data or metadata objects selected for job
Master table "SYSTEM"."SYS_IMPORT_TABLE_02" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TABLE_02": system/******** TABLES=EXP_SB_HEADER_TMP DIRECTORY=RMS_DATA_PUMP DUMPFILE=EXP_SB_HEADER_TMP.dmp LOGFILE=EXP_SB_HEADER_TMP_impdp.log REMAP_SCHEMA=sss_exp_test:sss_exp
Job "SYSTEM"."SYS_IMPORT_TABLE_02" successfully completed at 21:06:38
i am not sure what is your goal?
Did you want to export/import your table one by one. Or did you want to import your table into a new schema?
Table "EXP_SB_HEADER_TMP" exist in 11g development env in "sss_exp_test" schema.I have exported this table from Development(11g env).Now i want to import in Testing/QA env that is having 10g version(10.2.0.5).In QA env i want to import this table(EXP_SB_HEADER_TMP) in "sss_exp" schema.
Hope it is clear to you now.
OK in this case you need remap_schema.
As is cannot see it correct in your example. Did you have used tables=<source_user>.EXP_SB_HEADER_TMP and remap_schema=<source_user>:<destination_user>
Source User is the User the export is taken.
we will create a dummy table then test this one and share output with you.
we have done with this command .
impdp system DIRECTORY=RMS_DATA_PUMP DUMPFILE=EXP_SB_HEADER_TMP.dmp REMAP_SCHEMA=sss_exp:akm remap_tablespace=EXP_TBLS_DATA:Global_rms table_exists_action=append
import of table is sucessful in 10g using above command..thanks..!!!!!!!!!!