Enhancement request: Alias for connect string

[Marco van der Linden]

I could not find any mention of this on the forums, so..

It would be nice if you could assign an alias to the connect string in the preferences/oracle/logon history tab, which would show both under the history button in the logon screen as well as in the status bar icon.

E.g. If I connect as apps@some_very_cryptic_database_name, _I_ know that it's the Dev DB, but is is almost similar to apps@some_very_cryptic_database_name_2, which appears to be the Test DB. If I could alias it is would connect to APPSDEV or APPSTST without having to wonder (or remember) all those cryptic database names and meaningless numbers.

 

[CTzen]

You can create meaninfull aliases in tnsnames.ora file, I usually add 'Fixed Users' entries like this:

>Project
user1@prod.sid.server.company.com
user2@prod.sid.server.company.com
--
user1@test.sid.server.company.com
user2@test.sid.server.company.com
--
user1@dev.sid.server.company.com
user2@dev.sid.server.company.com

The TNS Names aliases are long, but since I'm selecting them from list and not typing anymore, it works for me.