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
mlrmlr
Messages: 1
Registered: August 2007
Location: Los Angeles
Junior Member
Hello,

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
Littlefoot
Messages: 20901
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: Free tool to browse a database? execute queries? create PL/SQL packages? etc?
Next Topic: Enabling UTF-8 format in Toad
Goto Forum:
  


Current Time: Thu Dec 08 20:33:48 CST 2016

Total time taken to generate the page: 0.24707 seconds