Can I do data pump exp (not expdp) 开发者_JS百科from 11g db (source) then imp (not impdp) into the 10g db (target)? Is tha possible?
And how about from 10g db (source) to do exp and imp to 11g db(target)?
Thanks!
According to the Oracle docs you can specify that the job doing the export produce values in a given version. That is to say, you can tell the job doing the export to produce 10g output so that it can be accepted by the destination database. There are, of course, some caveats which must not be ignored. Specifically, check out the parameters for the OPEN
function on DBMS_DATAPUMP
.
You'd need to use a 10g exp to do the export from 11g and the 10g imp to import into 10g.
A 10g imp will refuse to work with an 11g exp
精彩评论