-
connect to DB from sqlplus using script
Hi DBA's
i am looking for a script that can be run from sqlplus to connect to multiple databases.
where the script has service name as variable and can prompt me to enter service name everytime i run the script.
i have installed oracle client on the windows machine which is using the tnsnames.ora to connect to the DB's which are on linux.
This task can be achived by typing
sql> conn system/password@testdb
but i am looking for something like this
sql> conn.sql
Enter DB_NAME : testdb (or whatever the DB i am trying to connect)
is there a way this can be acheived.
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|