I want to migrate full database from Oracle 9i to 11gR2 by using export and import Method.Can you please explain step by step for the same.
OS:-Solaris 10 64 bit
Database :- 22.214.171.124
OS:-windows 2008 64 bit
Database :- 126.96.36.199
Thanks in Advance
It's pretty simple really.
1) Export the 9i database using the 9i version of exp, present in the ORACLE_HOME/bin directory on the database server.
2) Import the resulting dump file into the 11g database using the 11g version of imp, present in the ORACLE_HOME\bin directory of the Window server.
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 0 guests