From: fcarpio@NOJUNKcomcast.net   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)