Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with database creation: Oracle 9.2.0
Why don't you use the database assistant, store the create scripts and
edit them ?
Chuckster wrote:
>
> 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:41:03 CDT