You'll have to set up an entry in your server's tnsnames.ora configuration file to point to the Oracle database on the other system. The Network Configuration Assistant (netca) can be used to do this. I'll assume the TNS entry in the file is called "remote_db." Once you have the TNS entry created in the tnsnames.ora configuration file, you can test it by using SQL*Plus to sign on to the remote database as follows:
sqlplus system/manager@remote_db select * from v$instance;
Querying V$INSTANCE should confirm that you have connected to the remote database. Once that is done, you can use the same "@tns_alias" construct with the import utility as follows:
imp userid=system@remote_db file=my_dump.dmp tables=my_table
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.