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
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.