create database paradigm
maxinstances 1
maxlogfiles
16
maxloghistory 200
maxdatafiles 300
character set
"WE8ISO8859P15"
datafile
'/global/hood/data/u03/oradata/PARADIGM/system.dbf'
size 250M
logfile
group 1
('/global/hood/data/u02/oradata/PARADIGM/log_g1_m1.dbf','/global/hood/data/u03/oradata/PARADIGM/log_g1_m2.dbf')
size 5M,
group 2
('/global/hood/data/u02/oradata/PARADIGM/log_g2_m1.dbf','/global/hood/data/u03/oradata/PARADIGM/log_g2_m2.dbf')
size 5M,
group 3
('/global/hood/data/u02/oradata/PARADIGM/log_g3_m1.dbf','/global/hood/data/u03/oradata/PARADIGM/log_g3_m2.dbf')
size 5M,
group 4
('/global/hood/data/u02/oradata/PARADIGM/log_g4_m1.dbf','/global/hood/data/u03/oradata/PARADIGM/log_g4_m2.dbf')
size 5M;
create rollback segment r0 tablespace system
storage (initial 100k next 100k minextents 2 maxextents 20);
alter rollback segment r0 online;
alter database datafile
'/global/hood/data/u03/oradata/PARADIGM/system.dbf' autoextend
on
next 50M maxsize 350M;
create tablespace RBS
datafile
'/global/hood/data/u03/oradata/PARADIGM/rbs.dbf'
size 100M
default storage (
initial 2M
next 2M
pctincrease
0
minextents
2);
create tablespace TEMP
datafile
'/global/hood/data/u03/oradata/PARADIGM/temp.dbf'
size 200M
default storage ( initial 500K
next 500K
pctincrease 0)
/
create tablespace TOOLS
datafile
'/global/hood/data/u03/oradata/PARADIGM/tools.dbf'
size 200M
default storage ( initial 250K
next 250K
pctincrease 0)
/
create rollback segment r01 tablespace rbs;
create rollback segment r02 tablespace rbs;
create rollback segment r03 tablespace rbs;
create rollback segment r04 tablespace rbs;
create rollback segment r05 tablespace rbs;
create rollback segment r06 tablespace rbs;
alter rollback segment r01 online;
alter rollback segment r02 online;
alter rollback segment r03 online;
alter rollback segment r04 online;
alter rollback segment r05 online;
alter rollback segment r06 online;
alter rollback segment r0 offline;
drop rollback segment r0;
REM Correct sys and system users for this db
alter user sys temporary tablespace temp;
alter user system temporary tablespace temp;
Prompt
Prompt Now run catalog and catprog scripts..
Prompt
spool off
1. Hardware Requirements
