Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Step by Step EXP / IMP database from Oracle 9i to Oracle 11g

user12038800Jun 1 2010 — edited Jun 1 2010

Please help on the captioned where I did the below

1. Use EXP to export the database from a Oracle9i database (O9_DB) OLD_Windows2003_SERVER

2. Install the Oracle 11g (default service name is ORCL) to a new Windows 2003 server and use the IMP to import the O9_DB, however, I need to create the same physical path as the OLD_Windows2003_SERVER (e.g E:\Oralce_9i\Ordata\) in order to complete the IMP

3. I can launch the SQL Developer and obtain the records count of evey tables being imported

However, is there any best / proper way to do the EXP/IMP, the ideal outcome would be

1. Create a new namespace say (OLDDB) which same as the Oracle9i database name so maybe I don't need to modify much on the application side to point to the new database ?

2. IMP the OLDDB to the new namespace OLDDB

Thanks in advance