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