Re: ORACLE - instance can only have one DB

Now there's a voice from the past. Dave Kosenko wrote: > In some regards, a "normal" Oracle database behaves much like > an Informix MODE ANSI database. As Art points out, in Oracle, > a table owned by a different user is not automatically seen. > Another example is that you are always in a transaction in an > Oracle database - there is no need to issue a BEGIN WORK statement. > > Dave > > On Mon, 24 May 2004 08:01:59 -0400, "Art S. Kagel" > <kagel@bloomberg.net> wrote: > > >>On Mon, 24 May 2004 04:15:05 -0400, Dirk Moolman wrote: >> >>Ya, but just to muddy the waters, you can have multiple 'schemas' in a single >>Orable database/instance and the tables in one schema are not visible to a >>process connected to another schema. Sounds suspiciously like a separate >>database to me but with the system catalog overhead of all databases mixed >>together. >> >>Art S. Kagel > >