Re: Creating database manually

Pawel Młyński 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?

write a create database script and save it on a local hard disk modify the init.ora
start SQL*Plus

SQL> / as sysdba
SQL> startup nomount
SQL> pfile=<path_and_init_dot_ora_file_name>
SQL> @<path_and_script_name>

Some samples can be found at: http://www.psoug.org click on Morgan's Library
click on database

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)