Help with database creation: Oracle 9.2.0

From: Chuckster <chuckycarson_at_networkcloud.com>
Date: Tue, 30 Jul 2002 18:11:12 -0700
Message-ID: <3D473930.8000405@networkcloud.com>

I have pieced together this script but it gives me ORA-30014 at line1. Metalink wasn't too helpful. I am pretty solid with Oracle 8.1.7 but some of the terminology in this script is new to me. I found this script on google. (I merely changed the mount points and instance name)

I start the script as follows:
$ORACLE_HOME/bin/sqlplus /nolog @create_database.sql

Here is the script (create_database.sql):

connect SYS/change_on_install as SYSDBA

spool create_RHUGGA_database.log

startup nomount

SELECT 'START TIME: ' || TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') as Start_Time
FROM dual;

CREATE DATABASE "RHUGGA" NOARCHIVELOG

     MAXLOGFILES             32
     MAXLOGMEMBERS           5
     MAXDATAFILES            600
     MAXINSTANCES            10
     MAXLOGHISTORY           1000

DATAFILE
'/u01/oradata/RHUGGA/system01.dbf' size 200M
   REUSE
   AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE temp

         TEMPFILE '/u01/oradata/RHUGGA/temp01.dbf' SIZE 100M REUSE
         EXTENT MANAGEMENT LOCAL UNIFORM SIZE 500K

UNDO TABLESPACE "UNDOTBS" DATAFILE
'/u01/oradata/RHUGGA/undotbs01.dbf' SIZE 100M
   REUSE
   AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED

CHARACTER SET               WE8ISO8859P1
NATIONAL CHARACTER SET      UTF8

LOGFILE
   GROUP 1

  ('/u01/oradata/RHUGGA/redo_g01a.log',

'/u02/oradata/RHUGGA/redo_g01b.log',
'/u03/oradata/RHUGGA/redo_g01c.log') SIZE 5M,
   GROUP 2
( '/u01/oradata/RHUGGA/redo_g02a.log',

'/u02/oradata/RHUGGA/redo_g02b.log',
'/u03/oradata/RHUGGA/redo_g02c.log') SIZE 5M,
   GROUP 3
( '/u01/oradata/RHUGGA/redo_g03a.log',

'/u02/oradata/RHUGGA/redo_g03b.log',
'/u03/oradata/RHUGGA/redo_g03c.log') SIZE 5M
/

<SNIP>

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Tue Jul 30 2002 - 20:11:12 CDT