Locating exp920 executable
I need to export a 10g table into a 9i database. I want to run an export using a lower version under 10g. Where do I need to look for the exp920 executable?
ora_10g_db = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = ora10ghost.acme.com) (PORT = 1521)) ) (CONNECT_DATA = (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.
Dig Deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments