Re: Connecting to non-default database in Oracle 7

Rob, you can create different "schema's" i.e. almost like user's, in one Oracle database - and by using a different "connect" statement, switch between the same set of tables defined for each user. Or, you can set up completely different sets of physical database files and choose between the database to select by changing the Oracle SID (System IDentifier). The first style sounds closer to your description of SQL Server ... hope that helps a little -- on which OS are you running Oracle?

Jeremy Russell

"Robert Yang" <NOSPAM_ryang_at_teleport.com_NOSPAM> wrote:

>We are porting from MS SQL Server 6.5 to Oracle 7.3 and are quite
>confused, as you might expect, so please bear with me 8)
>
>There is a concept in SQL Server of multiple databases on a given
>server which can contain the same schema (tables, stored procedures, etc.).
>When connecting with DB-Lib, the dbuse() API can be used to set the
>desired default database, so that SQL commands like
>"Select Name from My_Table" can be executed.
>
>However, I cannot see how to do this with OCI or even Embedded SQL.
>It would seem that the database name must be specified for non-default
>databases, e.g. "Select Name from MyDatabase.MyTable".
>
Received on Tue Apr 21 1998 - 07:04:34 CDT