158 lines
4.1 KiB
SQL
158 lines
4.1 KiB
SQL
spool cr_tbs_mnp.log
|
|
Set Echo ON;
|
|
Connect / as SYSDBA
|
|
/
|
|
|
|
create tablespace TAB_DESC
|
|
datafile '/dev/rt_desc_8G' size 8190M autoextend off
|
|
extent management local uniform size 128K
|
|
segment space management auto
|
|
blocksize 8k
|
|
/
|
|
|
|
create tablespace TAB_SMALL
|
|
datafile '/dev/rt_small_8G' size 8190M autoextend off
|
|
extent management local uniform size 16M
|
|
segment space management auto
|
|
blocksize 8k
|
|
/
|
|
|
|
create tablespace TAB_MEDIUM
|
|
datafile '/dev/rt_medium1_8G' size 8190M autoextend off
|
|
extent management local uniform size 64M
|
|
segment space management auto
|
|
blocksize 8k
|
|
/
|
|
alter tablespace TAB_MEDIUM add datafile '/dev/rt_medium2_8G' size 8190M
|
|
/
|
|
alter tablespace TAB_MEDIUM add datafile '/dev/rt_medium3_8G' size 8190M
|
|
/
|
|
|
|
create tablespace TAB_BIG
|
|
datafile '/dev/rt_big1_8G' size 8190M autoextend off
|
|
extent management local uniform size 128M
|
|
segment space management auto
|
|
blocksize 8k
|
|
/
|
|
alter tablespace TAB_BIG add datafile '/dev/rt_big2_8G' size 8190M
|
|
/
|
|
alter tablespace TAB_BIG add datafile '/dev/rt_big3_8G' size 8190M
|
|
/
|
|
alter tablespace TAB_BIG add datafile '/dev/rt_big4_8G' size 8190M
|
|
/
|
|
|
|
create tablespace TAB_HUGE
|
|
datafile '/dev/rt_huge1_8G' size 8190M autoextend off
|
|
extent management local uniform size 256M
|
|
segment space management auto
|
|
blocksize 8k
|
|
/
|
|
alter tablespace TAB_HUGE add datafile '/dev/rt_huge2_8G' size 8190M
|
|
/
|
|
alter tablespace TAB_HUGE add datafile '/dev/rt_huge3_8G' size 8190M
|
|
/
|
|
alter tablespace TAB_HUGE add datafile '/dev/rt_huge4_8G' size 8190M
|
|
/
|
|
|
|
create tablespace TAB_HUGE_2
|
|
datafile '/dev/rt_huge2_1_23G' size 23030M autoextend off
|
|
extent management local uniform size 512M
|
|
segment space management auto
|
|
blocksize 8k
|
|
/
|
|
|
|
alter tablespace TAB_HUGE_2 add datafile '/dev/rt_huge2_2_23G' size 23030M
|
|
/
|
|
|
|
alter tablespace TAB_HUGE_2 add datafile '/dev/rt_huge2_3_23G' size 23030M
|
|
/
|
|
|
|
create tablespace TAB_IDX_SMALL
|
|
datafile '/dev/rt_idx_small_8G' size 8190M autoextend off
|
|
extent management local uniform size 16M
|
|
segment space management auto
|
|
blocksize 8k
|
|
/
|
|
|
|
create tablespace TAB_IDX_MEDIUM
|
|
datafile '/dev/rt_idx_med3_8G' size 8190M autoextend off
|
|
extent management local uniform size 64M
|
|
segment space management auto
|
|
blocksize 8k
|
|
/
|
|
alter tablespace TAB_IDX_MEDIUM add datafile '/dev/rt_idx_med1_8G' size 8190M
|
|
/
|
|
alter tablespace TAB_IDX_MEDIUM add datafile '/dev/rt_idx_med2_8G' size 8190M
|
|
/
|
|
|
|
create tablespace TAB_IDX_BIG
|
|
datafile '/dev/rt_idx_big1_8G' size 8190M autoextend off
|
|
extent management local uniform size 128M
|
|
segment space management auto
|
|
blocksize 8k
|
|
/
|
|
alter tablespace TAB_IDX_BIG add datafile '/dev/rt_idx_big2_8G' size 8190M
|
|
/
|
|
alter tablespace TAB_IDX_BIG add datafile '/dev/rt_idx_big3_8G' size 8190M
|
|
/
|
|
|
|
create tablespace TAB_IDX_HUGE_2_1
|
|
datafile '/dev/rt_idx_h_2_11_8G' size 8190M autoextend off
|
|
extent management local uniform size 512M
|
|
segment space management auto
|
|
blocksize 8k
|
|
/
|
|
alter tablespace TAB_IDX_HUGE_2_1 add datafile '/dev/rt_idx_h_2_12_8G' size 8190M
|
|
/
|
|
alter tablespace TAB_IDX_HUGE_2_1 add datafile '/dev/rt_idx_h_2_13_8G' size 8190M
|
|
/
|
|
|
|
create tablespace TAB_IDX_HUGE_2_2
|
|
datafile '/dev/rt_idx_h_2_21_8G' size 8190M autoextend off
|
|
extent management local uniform size 512M
|
|
segment space management auto
|
|
blocksize 8k
|
|
/
|
|
alter tablespace TAB_IDX_HUGE_2_2 add datafile '/dev/rt_idx_h_2_22_8G' size 8190M
|
|
/
|
|
alter tablespace TAB_IDX_HUGE_2_2 add datafile '/dev/rt_idx_h_2_23_8G' size 8190M
|
|
/
|
|
|
|
create tablespace TAB_MNP_CONSOLE
|
|
datafile '/dev/rt_mnp_cons1_8G' size 8190M
|
|
extent management local
|
|
segment space management auto
|
|
blocksize 8k
|
|
/
|
|
alter tablespace TAB_MNP_CONSOLE add datafile '/dev/rt_mnp_cons2_8G' size 8190M
|
|
/
|
|
|
|
create tablespace TAB_MNP_CONSOLE_LOG
|
|
datafile '/dev/rt_cons_log_8G' size 8190M
|
|
extent management local
|
|
segment space management auto
|
|
blocksize 8k
|
|
/
|
|
|
|
create tablespace TAB_MNP_CONSOLE_INDX
|
|
datafile '/dev/rt_cons_i_8G' size 8190M
|
|
extent management local
|
|
segment space management auto
|
|
blocksize 8k
|
|
/
|
|
|
|
create tablespace TAB_DWH
|
|
datafile '/dev/rtab_dwh_8G' size 8190M
|
|
extent management local
|
|
segment space management auto
|
|
blocksize 8k
|
|
/
|
|
|
|
create tablespace USR
|
|
datafile '/dev/rusr_4G' size 4090M
|
|
extent management local
|
|
segment space management auto
|
|
blocksize 8k
|
|
/
|
|
|
|
spool off; |