Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to Import 11g dump into 10g on HP UX B.11.31

akm-2205195Oct 14 2012 — edited Oct 15 2012

Dear All,

I have taken expdp dump from 11g database running in Development env.Now i want to import this dump into 10g database running in QA env.

while taking export from 11g database i used this script and backup was sucesssful

expdp system TABLES=sss_exp_test.EXP_SB_HEADER_TMP VERSION=10.2 DIRECTORY=RMSDEV_IMP_DIR DUMPFILE=EXP_SB_HEADER_TMP.dmp LOGFILE=EXP_SB_HEADER_TMP_expdp.log

When i trying to import this dump in 10g getting error.

impdp system TABLES=sss_exp.EXP_SB_HEADER_TMP DIRECTORY=RMS_DATA_PUMP DUMPFILE=EXP_SB_HEADER_TMP.dmp LOGFILE=EXP_SB_HEADER_TMP_impdp.log

Import: Release 10.2.0.5.0 - 64bit Production on Sunday, 14 October, 2012 19:58:53

Copyright (c) 2003, 2007, Oracle. All rights reserved.
Password:

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-39002: invalid operation
ORA-39040: Schema expression "SCHEMAS" must identify exactly one schema.

Please help me .