Home » SQL & PL/SQL » Client Tools » Adding a database to the Oracle Login
Adding a database to the Oracle Login [message #263410] Thu, 30 August 2007 00:09 Go to next message
Messages: 1
Registered: August 2007
Location: Los Angeles
Junior Member

I am new to the PL/SQL Developer tool. I log on to several databases to run numerous SQL scripts. I am in need of running a SQL scrip in another database but I do not know how to add it to the Oracle Login sreen.

I was told that you have to add the new database to the TNSNAMES.ORA file, is this true? If so, is there a particular format that I follow?

Thanks so much.
Re: Adding a database to the Oracle Login [message #263422 is a reply to message #263410] Thu, 30 August 2007 00:37 Go to previous message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
The easiest way is to copy existing database alias and paste it at the bottom of the file, change information that is different (database alias, host name, port number, ...), save the file and that should do it.
Previous Topic: & sign in where clause
Next Topic: Toas sys login
Goto Forum:

Current Time: Sun Aug 20 23:43:00 CDT 2017

Total time taken to generate the page: 0.05621 seconds