Expdb/impdb full schema on migration of database, from 10g to 11g?
Dear Oracle Experts,
May I use Oracle data pump on database migration, from 10g to 11g?
1. Database A, 10g on Windows 2008 R2 64bit
select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for 64-bit Windows: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
2. Database B, will be 11g (11.2.0.4) on a new server box, with Windows 2012
After I create a new database on the new server, may I use expdb to get a dump file with full schema and impdb the dump into 11g database?
My database size was 11GB. There only is one application owner (schema).