This content has been marked as final. Show 5 replies
Can I import a full export dumpfile from oracle database v18.104.22.168 into an oracle database v22.214.171.124?
Would the same process hold for importing an oracle schema exported from an oracle database 126.96.36.199 into an oracle database v188.8.131.52?the rule or restriction is that the export must be done specifying or with the lower version;
then it can be imported into higher version without any additional restriction.
Yes, the idea of exporting is to ease the differences between versions. There isn't much difference between the patch levels you have listed. There is a version parameter for if you are importing to a lower version that doesn't have all the features of the export version. See http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_import.htm#SUTIL944 (and there are MOS documents explaining in much detail).
1) Yes, you can import full database dump from 184.108.40.206 to 220.127.116.11.
2) Yes, it applies to schema import as well
Edited by: raams on Nov 16, 2012 8:09 AM
jgaoiran wrote:Yes you can import ,
Can I import a full export dumpfile from oracle database v18.104.22.168 into an oracle database v22.214.171.124? Or would I need to first import into an oracle database v126.96.36.199 and then upgrade the database to v188.8.131.52?
Would the same process hold for importing an oracle schema exported from an oracle database 184.108.40.206 into an oracle database v220.127.116.11?Yes
Why are you talking about original import when the OP is asking about impdp in 11.2?