I need to export a 10g table into a 9i database. I want to run an export using a lower version under 10g. When I look at the 10g bin directory, I do not see an executable named exp920. Where do I need to look for this executable?

    Requires Free Membership to View

You'll have to install Oracle 9i on this database server if you want to run the executable on that server. However, so long as the server you have running 9i can connect to the server running 10g, you can use the Oracle 9i export utility on the other server and perform the export across your network. In your 9i ORACLE_HOME/network/admin directory, you will find a tnsnames.ora configuration file. You will have to add an entry to that file that looks like the following:
ora_10g_db =
      (ADDRESS =
         (PROTOCOL = TCP)
         (HOST = ora10ghost.acme.com)
         (PORT = 1521))
      (SERVICE_NAME = orcl)
You can call this tns alias anything you want. I called it "ora_10g_db," but you can use any meaningful name you want. You will also have to change the database HOST, the PORT of the Oracle Listener on that server and the database SID (SERVICE_NAME) to match the values specific to your Oracle 10g database. Once done, you can connect to that database with the export utility in your Oracle 9i server as follows:
exp userid=system@ora_10g_db file=.....
The "@ora_10g_db" tells exp that this is a remote database and to look up the connection information in the tnsnames.ora configuration file.

This was first published in January 2007

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: