(wrong string) ‚€“ is they a way to provide indirection for db name?

From: ddf <oratune_at_msn.com>
Date: Mon, 5 Jan 2009 09:35:48 -0800 (PST)
Message-ID: <25cae9a8-dfab-4748-93c0-bd7a38a20bcb_at_v13g2000vbb.googlegroups.com>

On Jan 5, 11:24†am, zigzag..._at_yahoo.com wrote:
> A third party application is using JDBC URL to connect to Oracle,
> jdbc:oracle:thin:scott/tiger_at_MyOracleHost:1521:MyDB
> For some reason in third party application, same URL has to be used
> for
> Dev, QA and Production. I know using /etc/hosts (Or its equivalent in
> Windows), I can point MyOracleHost to different hosts. But, is there
> any way to point †MyDB to different database names.

No, as that is the SID of the instance/database for the connection; it's not a TNS alias.

David Fitzjarrell Received on Mon Jan 05 2009 - 11:35:48 CST

Original text of this message