Re: ORACLE - instance can only have one DB

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