1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
|
REM * Start the SPTNAT instance (ORACLE_SID here must be set to SPTNAT).
REM *
set echo on
connect / as sysdba
startup nomount
REM *
REM * Create the SPTNAT database.
REM *
create database "SPTNAT"
character set "WE8ISO8859P15"
datafile
'/appli/oradata01/SPTNAT/SPTNAT_system_01.dbf' size 1500M reuse
logfile
group 1 ('/appli/oraredolog01/SPTNAT/SPTNAT_redo1_1.rdo',
'/appli/oraredolog02/SPTNAT/SPTNAT_redo1_2.rdo') size 350M ,
group 2 ('/appli/oraredolog01/SPTNAT/SPTNAT_redo2_1.rdo',
'/appli/oraredolog02/SPTNAT/SPTNAT_redo2_2.rdo') size 350M
maxloghistory 1000
default temporary tablespace TEMP tempfile
'/appli/oradata01/SPTNAT/SPTNAT_temp_01.dbf' size 200M
extent management local uniform size 2048 K
undo tablespace UNDO datafile
'/appli/oradata01/SPTNAT/SPTNAT_undo_01.dbf' size 500M;
create tablespace TAB_SPT_M_01 datafile
'/appli/oradata02/SPTNAT/SPTNAT_tab_m_01.dbf' size 500M reuse,
'/appli/oradata02/SPTNAT/SPTNAT_tab_m_02.dbf' size 500M reuse,
'/appli/oradata02/SPTNAT/SPTNAT_tab_m_03.dbf' size 500M reuse,
'/appli/oradata02/SPTNAT/SPTNAT_tab_m_04.dbf' size 500M reuse
default storage (
initial 500M
next 50M
pctincrease 0
minextents 1
);
create tablespace IDX_SPT_M_01 datafile
'/appli/oradata03/SPTNAT/SPTNAT_idx_m_01.dbf' size 800M reuse
default storage (
initial 20M
next 2M
pctincrease 0
minextents 1
);
spool off
shutdown
exit; |