CODEWITHSUNDEEP
oracle-databaseplsqldeveloper
John Willmer Cubillos Vega
John Willmer Cubillos Vega

Reputation: 35

Can I create a connection without modifying tnsnames.ora?

Can I create a connection without modifying tnsnames.ora?

I have a db in a remote server which is accesible using ping or telnet. However, I don't have the permissions to modify the tnsnames.ora file.

How could I access the db using PL/SQL Developer?

Upvotes: 1

Views: 1049

Answers (1)

Carlo Sirna
Carlo Sirna

Reputation: 1241

You can also write the whole connect string in the "database" field (you must edit it in order to be on a single line of text), instead of using its alias defined in tnsnames.ora

Like in this example: Like this

Upvotes: 1

Related Questions