Re: Creating database manually

From: Hans Erik Busk <tbf_at_cn.stam.dk>
Date: Mon, 03 Jan 2005 20:12:28 +0100
Message-ID: <4q5jt092kfbqpnnodvg0pctrj5nle9v5ks@4ax.com>

On Mon, 3 Jan 2005 17:46:36 +0100, Pawel M³yñski <pmg3_at_op.pl> wrote:

>I have installed Oracle Database 9.2.0.1.0.
>I have not created any databases yet. Instead of using ODCA I would like to
>create a database manually. In order to do it I have to issue CREATE
>DATABASE command. Unfortunatelly I don't know how to gain access to SQL, is
>there any way I can do it?

On windows you have to create a service first with oradim. You will need an *.ini file.
When the service is running you can connect to that from SQLPLUS.

It is a fine educational excersize to create the databse yourself, and good for finetuning a production database (if you know what you are doing .-)
But don't make it harder than necessary. Use ODCA to create the scripts You don't have to create the database! Then study and modify the script to your whishes.

Hans Erik Busk
Denmark Received on Mon Jan 03 2005 - 13:12:28 CST