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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
