Oracle Database Discussions

Hello Everybody,

Please I have to estimate and then maybe do this migration task:

1 - Migrate DB (data and all objects) from existing Oracle 9.2.0.1 running on Windows XP to Oracle 12c on Windows 10

2 - Make sure that all DB objects pacakges, types, trigers etc ... will be valid and operational on new system

I was searching for some information and I found some discussions but nobody with concrete experience with simmilar task.

• install Oracle 12c and migrate data from 9i to 12c on Solaris (this is somthinkg simmilar, but different OS)
• http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf (I have read this articke about Oracle DB migration and it looks like the Method 4 is the most sutiable)
  1. DBUA or command line upgrades
  2. Full Transportable Export/Import or Transportable Tablespaces
  3. Oracle D ata Pump Export/Import
  4. Original Export/Import - looks like this method is the best for such task (steps bellow)
     • Export the source database to a dump file:
     • exp src92 admin/<passwd> full=y file=exp9i.dmp
     • Make the dump file available on the destination system, either by copying it to the new system or placing it on a network-mounted disk.
     • Create a CDB on the destination system, including a PDB into which you will import the source database.
     • Import the original Export dump file into the destination PDB:
     • imp pdbadmin/<passwd> full=y file=exp9i.dmp

I have no experieces with task like this, but I know there are a lot of changes between Oracle 9i and 12c that can create a lot of problems during the import and validation

My Questions are:

1. Can I use EMP/IMP to export whole DB with all STORE DATA and ALL DB OBJECTS like tables, views, packages, tablespaces ... (So it will export me everything ? And it will import me everything?)
2. I dont understand this sentence: Original Export/Import may not be able to migrate data from installed options in your database.
3. Is there anybody who already done such task and have experiance how to proceed or what is the best approach?
4. If I have no many experiance with such instalation and migration do you think it is possible to handle it or it will be a nightmare
5. Can you decribe me what problems I can expect and how to deal with them?

Thank You very much

Zoffob