Home » Infrastructure » Unix » Importing through Shell
Importing through Shell [message #198298] Mon, 16 October 2006 08:44 Go to next message
marlon_loyolite
Messages: 66
Registered: July 2006
Member
Hi Friends ,
I have run shell scripts for importing from my local system through TELNET It was running fine on the server.But now I need to import the same dump file into my local database.The ORACLE_SID refering to the database in the server is same as the database in my local system.

So how to tell through the scripts that I need to connect to my local system.

If anyone could explain this it could be of great help.

Regards
Marlon.

Re: Importing through Shell [message #198312 is a reply to message #198298] Mon, 16 October 2006 09:26 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> So how to tell through the scripts that I need to connect to my local system.
Post your script
or alteast the relevant part of it.
All you need is
imp user/pass@localdatabase .... #localdatabase is the tnsentry in tnsnames.ora that will identify you local database.
or
export ORACLE_SID=yourlocaldatabasesid #in unix
set ORACLE_SID=youlocaldatabasesid #in windows
imp user/pass ....
Previous Topic: Creating a second database on AIX box
Next Topic: Oracle IMP - canceling a import
Goto Forum:
  


Current Time: Tue Dec 06 08:23:03 CST 2016

Total time taken to generate the page: 0.18421 seconds