From: forbrich@yahoo.net   
      
   oracle wrote:   
      
   >   
   > I go there but did not find any .doc   
   > I want to manually create the new database   
   > without using Database Configuration Assistant.   
      
   Sorry - misunderstood the question.   
      
   Go to the 'SQL Reference' manual in the http:/docs.oracle.com document   
   archives and look for the 'CREATE DATABASE' command.   
      
   It's a relatively complicated command which requires understanding of   
   system, temporary, rollback/undo, and data tablespaces, block sizes (and   
   related SGA impacts), as well as a number of other issues.   
      
   There are simply too many variations to give you any advice over the   
   newsgroup without detailed understanding of your needs.  Which explains why   
   Oracle makes the DBCA available.   
      
   Note that most people who ask this question are using the SQL Server/Sybase   
   definition of 'Database'. Oracle's equivalent is 'SCHEMA'.  Please verify   
   (at least for yourself) that you really need a new database and not just a   
   new schema.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)