Q
Manage Learn to apply best practices and optimize your operations.

How to use imp to restore table to another computer

How can I use imp on a network to restore a table on the server to another computer?

How can I use imp on a network to restore a table on the server to another computer? Thanks.

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close