RE: Help Oracle 9i db creation scripts

Here is one that I used for my test database:

create database KED9
  maxinstances 1
  maxloghistory 200
  maxlogfiles 4
  maxlogmembers 4
  maxdatafiles 100
  character set us7ascii
  controlfile reuse
datafile '/u801/oradata/KED9/system_01.dbf' size 300M reuse default temporary tablespace temp

        tempfile '/u802/oradata/KED9/temp_01.dbf' size 100M reuse
        extent management local uniform size 1M
undo tablespace undo_tbs     
        datafile '/u803/oradata/KED9/undo_tbs_01.dbf' size 300M reuse
logfile group 1 ('/u804/oradata/KED9/redo_g1m1.log') size 100M reuse,
        group 2 ('/u805/oradata/KED9/redo_g2m1.log') size 100M reuse,
        group 3 ('/u806/oradata/KED9/redo_g3m1.log') size 100M reuse

@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql

create tablespace users
datafile '/u801/oradata/KED9/users_01.dbf' size 100M reuse extent management local uniform size 1M;

create tablespace data
datafile '/u802/oradata/KED9/data_01.dbf' size 200M reuse extent management local uniform size 1M;

create tablespace indx
datafile '/u803/oradata/KED9/indx_01.dbf' size 200M reuse extent management local uniform size 1M;

• Kirti

-----Original Message-----
Sent: Monday, February 17, 2003 10:54 AM To: Multiple recipients of list ORACLE-L

Oracle 9i R2
Solaris 8
LIST,
I always create my databases from scripts, and I have Oracle 8i create database scripts. I've been trying to get Oracle 9i DBCA working for several days, and all I get is the initializing screen. I've checked metalink, google, and orafaq for resolutions, but I'm running out of time. Does someone have a script for Oracle 9i database creation I can use as a base for my new 9i database with the new features included? TIA
M.Godlewski

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).