Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: creating an instance with command line tools
Christoph Kukulies <kuku_at_gil.physik.rwth-aachen.de> wrote:
>I need to know a way to create a database using solely
>batch tools, i.e. SRVMGR or something to create an Oracle
>DB instance after the customer has installed the server from the CD.
See the CREATE DATABASE command in the SQL reference manual. You need to specify at least log files and a datafile for the system tablespace. After that you can use CREATE TABLESPACE and build any schema objects you feel like.
I find a useful place to start is with a script created with the dbasst tool, and then hack it to do what I want (today's top tip - you can create tablespaces faster by just specifing a single datafile in the CREATE statement, then add the rest of the datafiles in parallel with ALTER TABLESPACE commands).
-- Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/Received on Sun Jun 03 2001 - 13:24:49 CDT