Re: Creation Scripts for Unix

From: fro_doe <fro_doeNOfrSPAM_at_hotmail.com.invalid>
Date: 2000/07/21
Message-ID: <1a6841d5.372999be@usw-ex0102-016.remarq.com>#1/1

Well, the most simple way I can think of (assuming you have the software already installed) is this:

$ export ORACLE_SID=TEST
$ touch $ORACLE_HOME/dbs/init$ORACLE_SID.ora
$ sqlplus '/ as sysdba'

SQL> startup nomount
SQL> create database TEST;

This database won't be useful for much other than testing, but it's a database nevertheless.

Doug.

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Fri Jul 21 2000 - 00:00:00 CDT