Very basic question

From: FC <fcarpio_at_NOJUNKcomcast.net>
Date: Sat, 03 Sep 2005 12:21:38 -0400
Message-ID: <t9GdnSMUBvQWUITeRVn-vg@comcast.com>

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?

Do you know of any on line tutorials that deal with creating multiple databases in oracle? Any help will be greatly appreciated.

I use MS SQLServer 2k and I could use the download versions of oracle (9i or 10g) to learn this subject.

Thanks in advance.

FC Received on Sat Sep 03 2005 - 11:21:38 CDT