| Importing through Shell [message #198298] |
Mon, 16 October 2006 08:44  |
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  |
 |
Mahesh Rajendran
Messages: 10707
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 ....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
