Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: creating an instance with command line tools

Re: creating an instance with command line tools

From: Andrew Mobbs <andrewm_at_chiark.greenend.org.uk>
Date: 03 Jun 2001 19:24:49 +0100 (BST)
Message-ID: <52y*8aQXo@news.chiark.greenend.org.uk>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US