MSSQL "database" is roughly equivalent to Oracle "schema", or a user
that has some objects in its ownership. You may define users that do
not have any objects in their ownership - you may treat these as
empty schemas (or databases in MSSQL sense.) So you actually need
to create one Oracle database and then create one or more users in
that database. When you connect as one particular user, you can create
various database objects (tables, indexes, views, stored procedures, etc.)
which will go into this user's schema. You can then control access to these
objects by granting or revoking certain privileges to other Oracle users.
By default, only the owner of the database object has access to this particular
object (plus users with system-wide privileges like SELECT ANY TABLE,
etc.)
For better understanding, Oracle8i Concepts guide is irreplaceable. You
can access it online at http://otn.oracle.com (site requires registration,
which is free and does not trigger any spam.) or download it in PDF
form for offline reading from the same site. Just start with Part I: What
is Oracle, and eventually it will all become clear. :)
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Trevis" <trevisc_at_yahoo.com> wrote in message
news:30e0b07d.0209300541.3a5cd298_at_posting.google.com...
> Hello all you Oracle Gurus!
>
> I'm really confused about setting up more than one database in oracle.
> I've read multiple posts about "Instances" and "Schemas" and i'm more
> confused now then ever. Here is what I want to accomplish. I want to
> set up a box that I can use for testing VB applications against.
> There are multiple applications that use different databases(tables).
> In SQL server I just create a new "database" and create an odbc
> connection that uses that database's tables as its default. How do I
> accomplish this in Oracle 8.1.7? I've tried creating 2 databases but
> it seems like the first "Instance" that loads hogs up all the
> resources and even though I see the second database I can't access it.
> I'm sure i'm missing something really simple because I will be the
> only one accessing the data and I don't care about performance I just
> care about having different databases on one machine. Please post any
> friendly advice. My company won't pay for training but I could
> purchase books if there are any that would help.
>
> Thank you!
>
> T
Received on Mon Sep 30 2002 - 09:13:18 CDT
