How to convert a dump file in oracle 11g to oracle 9i using Oracle 10g

IN SYSTEM WITH ORACLE 11G

You have your dump file myfile.dmp in oracle 11g here.First you need to import this data into an oracle user.

Step 1: Import the data into Oracle 11g user.

Go to Start->Sql plus and login.The syntax is

USERNAME/PASSWORD@HOSTNAME

Create a new user

Create a new user and grant rights to the user using the following commands:

CREATE USER USER11 IDENTIFIED BY USER11;
GRANT DBA TO USER11;

Go to cmd and type the following to import the dump data into user11:

IMP USER11/USER11@HOST11 FILE=(path to the dump file)\myfile.dmp FULL=Y

Let the import terminate.This takes some time depending on the file size.

IN SYSTEM WITH ORACLE 10G

You can either go to the system with Oracle 10g or use Remote Desktop connection.If you are not using Remote Desktop connection,remember to connect to the system with oracle 11g from here.You can use the command CONN USERNAME/PASSWORD@HOST11 to get connected.

Also create a folder(say in D drive) where you can save this file.

Step 2: Export the file in Oracle 10g

Go to cmd ,type the following and press enter:

EXP USER11/USER11@HOST11 FILE=(path to the newly created folder)/myfile.dmp OWNER=USER11

Let the export terminate.

Step 3: Import the data into Oracle 10g user.

Now,we have to import the data into a user in Oracle 10g.For this,first create a new user.

Go to Sql command line and login using the command:

CONN USERNAME/PASSWORD@HOST10

Create a new user:

Create a new user and grant rights to the user using the following commands:

CREATE USER USER10 IDENTIFIED BY USER10;

GRANT DBA TO USER10;

Go to cmd ,type the following and press enter to import the dump data into user10:

IMP USER10/USER10@HOST10 FILE=(path to the dump file)\myfile.dmp FULL=Y

Let the import terminate.Now we have the data in Oracle 10g in the user user10.We have to again export it in Oracle 9i.

IN SYSTEM WITH ORACLE 9i

In the same way as we did before,you can either go to the system with oracle 9i or use Remote Desktop connection.If you are not using Remote Desktop connection,remember to connect to the system with oracle 9i from here.

Also create a folder(say in D drive) where you can save this file.

Step 4: Export the file in Oracle 9i.

Open cmd ,type the following and press enter:

EXP USER10/USER10@HOST10 FILE=(path to the newly created folder)/myfile.dmp OWNER=USER10

Let the export terminate.The myfile.dmp in the specified path is now in Oracle 9i.

More by this Author


Comments

No comments yet.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working