startup nomount pfile=$ORACLE_BASE/LIONDEV1/pfile/initLIONDEV1.ora

CREATE DATABASE "LIONDEV1"
CONTROLFILE reuse
MAXDATAFILES 200
MAXINSTANCES 1
MAXLOGFILES 32
MAXLOGMEMBERS 7
MAXLOGHISTORY 100
LOGFILE
GROUP 1 (
'$ORACLE_BASE/LIONDEV1/redo/LIONDEV1_redo_01.dbf' ) size 128M REUSE ,
GROUP 2 (
'$ORACLE_BASE/LIONDEV1/redo/LIONDEV1_redo_02.dbf' ) size 128M REUSE ,
GROUP 3 (
'$ORACLE_BASE/LIONDEV1/redo/LIONDEV1_redo_03.dbf' ) size 128M REUSE ,
GROUP 4 (
'$ORACLE_BASE/LIONDEV1/redo/LIONDEV1_redo_04.dbf' ) size 128M REUSE


DATAFILE '$ORACLE_BASE/LIONDEV1/data/LIONDEV1_system_01.dbf' size
300M REUSE AUTOEXTEND OFF

# sysaux DATAFILE '$ORACLE_BASE/LIONDEV1/data/LIONDEV1_system_01.dbf
size 300M REUSE AUTOEXTEND OFF

# DEFAULT TABLESPACE data_01 DATAFILE
'$ORACLE_BASE/LIONDEV1/data/LIONDEV1_data_01.dbf' SIZE 500M
AUTOEXTEND ON NEXT 128M MAXSIZE 1000M

DEFAULT TEMPORARY TABLESPACE temp TEMPFILE
'$ORACLE_BASE/LIONDEV1/temporary/LIONDEV1_temporary_01.dbf' size 500M
AUTOEXTENT OFF EXTENT MANAGEMENT LOCAL

UNDO TABLESPACE undo_01 DATAFILE
'$ORACLE_BASE/LIONDEV1/undo/LIONDEV1_undo_01.dbf' 500M
AUTOEXTENT OFF
CHARACTER SET WE8ISO8859P15
NATIONAL CHARACTER SET AL16UTF8
/
1. You can leave out extent management auto if you are in 9.2 because it
is the default.
2. Create only required tablespaces (system, undo, temp) and then run the
script to create additional ones when the database has been created. Less
debugging to worry about in the beginning. Hope this helps.

Sabina.

Oracle LazyDBA home page