This content has been marked as final. Show 5 replies
Can I import a full export dumpfile from oracle database v126.96.36.199 into an oracle database 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?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 18.104.22.168 to 22.214.171.124.
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 v126.96.36.199 into an oracle database v188.8.131.52? Or would I need to first import into an oracle database v184.108.40.206 and then upgrade the database to v220.127.116.11?
Would the same process hold for importing an oracle schema exported from an oracle database 18.104.22.168 into an oracle database v22.214.171.124?Yes
Why are you talking about original import when the OP is asking about impdp in 11.2?