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!

Error Importing Schema from 64bit to 32bit

774582Jun 8 2011 — edited Jun 11 2011

Hi Friends..
I have my
Source DB on Windows 2003 server..version is 11.1.0.7.0 and its 64bit
Target DB on Windows XP ..version is 11.1.0.6.0 and its 32bit

I have my schema named test.. i want to copy that scehma to my target DB

so i first exported it using expdp system/manager dumpfile=test.dmp logfile=testlog.log schemas=test version =11.1.0.6.0 ( coz its the version for target db)
It ran properly.. without error..then i copled the dmp file and pasted it to my target dB dpdump..
and then on Target DB windows XP 32bit. i used impdp command
impdp system/manager dumpfile=test.dmp logfile=imptest.log schemas=test

But it gives me errror

ORA-31694
ORA-02354
ORAA 00904.. --> cannot complete the SYSTEM01 table invalid identifier

Guys can you plz give me insight into it..Never got this error before..