Is doing a full data export (expdp) from an Oracle 10g (10.2.0.1.0) database and then doing an import of that dump file (impdp) into an 11.2.0.2 database a valid and acceptable upgrade path from 10g to 11g?
Upgrading 10g database to 11g database
oracleoracle-11g-r2upgrade
Best Answer
Sure-- there is even a chapter in the Upgrade Guide on using DataPump to move the data from the old database to the new database.