Re: Very basic question
Date: Sat, 03 Sep 2005 18:18:03 +0100
Message-ID: <vkmjh1phvffb1u6lbr57947q625jds1n6v_at_4ax.com>
FC <fcarpio_at_NOJUNKcomcast.net> wrote:
> Hello all:
> I have a very basic question about oracle database structures. I am
> coming from MS SQLServer where I have three "databases", each database
> has three "tables". I can access any table from any database from a SQL
> connection where each database has its own connection. Once connected I
> access each table from a SQL statement.
> OK, now I want to recreate the same database structure in oracle. What I
> do not understand is the concept of instance in oracle. Is an instance
> the same as a database? Can I have several instances (databases) in
> oracle and access them separately as in MS SQLServer? Or do I have to
> create one database that has all my 9 tables in it?
Create 3 schemas and use them like your MS SQL "databases".
Paul...
> FC
-- plinehan __at__ yahoo __dot__ __com__ XP Pro, SP 2, Oracle, 9.2.0.1.0 (Enterprise Ed.) Interbase 6.0.1.0; When asking database related questions, please give other posters some clues, like operating system, version of db being used and DDL. The exact text and/or number of error messages is useful (!= "it didn't work!"). Thanks. Furthermore, as a courtesy to those who spend time analysing and attempting to help, please do not top post.Received on Sat Sep 03 2005 - 19:18:03 CEST