From: paul@see.my.sig.com   
      
   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?   
      
      
   Create 3 schemas and use them like your MS SQL "databases".   
      
      
      
   Paul...   
      
      
   > FC   
      
      
   --   
      
   plinehan __at__ yahoo __dot__ __com__   
      
   XP Pro, SP 2,   
      
   Oracle, 9.2.0.1.0 (Enterprise Ed.)   
   Interbase 6.0.1.0;   
      
   When asking database related questions, please give other posters   
   some clues, like operating system, version of db being used and DDL.   
   The exact text and/or number of error messages is useful (!= "it didn't   
   work!").   
   Thanks.   
      
   Furthermore, as a courtesy to those who spend   
   time analysing and attempting to help, please   
   do not top post.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)