From: fcarpio@NOJUNKcomcast.net   
      
   FC 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?   
   >   
   > 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   
      
   Thanks for the replies, they cleared a lot of the blur but also raised   
   some more questions. I hope I do not become a pest here.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)