Oracle vs. SQL Server

From: Richard Hennessy <rhennessy_at_qumas.com>
Date: 14 Apr 2003 11:00:21 -0700
Message-ID: <13d248d1.0304141000.4eede6bb@posting.google.com>

Hi,
Does Oracle have a feature similar to SQL Server's "Inital Catalog" connection string attribute, which directs all queries to the tables of the specified database?

Basically I have an Oracle application where all the database tables are owned by the one user and these tables are accessed by other users using public synonyms. But, if I need to set up another database for my application, I need to create another Oracle instance (which is time consuming) as creating the same tables under a new owner user is not a problem but using public synonyms will render these new tables useless. So, I would like to be able to create one or more database for the same application database in the one instance.

I know I can qualify each table name with the owner but I don't want to use this if possible due to problems encountered previously.

Ideally, I would like an attribute that I could include as part of my ADO connection string that would direct the queries for that session to look at a particluar users tables, enabling me to do away with public synonyms?

Any ideas?
Thanks in advance! Received on Mon Apr 14 2003 - 13:00:21 CDT