To perhaps supply some more background to what Jeremy is saying: In
a database is a collection of files and memory area under the
set of server processes called the Instance. In order to gain
of the information in a database, you must log on (connect)
When you log on, you provide your userid/password
identifies the database to which you want to
connected to a database, you look at tables in your own
"Schema" in Oracle refers to a set of database objects
owner. Hence, if I am logged on as RONO, my
might be ROBERTY. We can each
example RONO.EMPLOYEE and
you need only refer to the table by name:
access someone else's schema.
(RONO.EMPLOYEE). The other option
just a way to tell Oracle that when I
if ROBERTY had no EMPLOYEE table
a synonym EMPLOYEE
EMPLOYEE, you
you are trying to have muliple users
is your best bet. If you are trying to
another set of tables another time
databases is probably what
you.
<353c8aa5.1938429_at_news.dircon.co.uk>,
you can create different "schema's" i.e. almost like user's, in
database - and by using a different "connect" statement,
same set of tables defined for each user. Or, you
different sets of physical database files and
to select by changing the Oracle SID
sounds closer to your
little -- on which OS
"Robert Yang" <NOSPAM_ryang_at_teleport.com_NOSPAM> wrote:
from MS SQL Server 6.5 to Oracle 7.3 and are quite
expect, so please bear with me 8)
multiple databases on a given
(tables, stored procedures, etc.).
dbuse() API can be used to set the
commands like
I cannot see how to do this with OCI or even Embedded SQL.
that the database name must be specified for non-default
"Select Name from MyDatabase.MyTable".
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Tue Apr 21 1998 - 12:48:24 CDT
