Home -> Usenet -> comp.databases.oracle -> Very basic question

Very basic question

From: FC <fcarpio_at_NOJUNKcomcast.net>
Date: Sat, 03 Sep 2005 12:21:38 -0400
Message-ID: <t9GdnSMUBvQWUITeRVn-vg_at_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 - 18:21:38 CEST












Original text of this message