Create TBS
create tablespace tbs_local_01
datafile '/u04/oradata/PROD/tbs_local_01_01.dbf' size 50m
extent management local
segment space management auto
create tablespace tbs_local_02
datafile '/u04/oradata/PROD/tbs_local_02_01.dbf' size 50m
extent management local uniform size 512k
segment space management auto
create tablespace tbs_local_03
datafile '/u04/oradata/PROD/tbs_local_03_01.dbf' size 50m
extent management local uniform size 1m
segment space management manual
create bigfile tablespace tbs_big_01
datafile '/u04/oradata/PROD/tbs_big_01_01.dbf' size 50m
extent management local uniform size 1m
segment space management auto
create temporary tablespace temp_member_1
tempfile '/u04/oradata/PROD/temp_member_1_01.dbf' size 25m
tablespace group temp_group
create temporary tablespace temp_member_2
tempfile '/u04/oradata/PROD/temp_member_2_01.dbf' size 25m
tablespace group temp_group
create temporary tablespace temp_member_3
tempfile '/u04/oradata/PROD/temp_member_3_01.dbf' size 25m
tablespace group temp_group
alter database default tablespace tbs_local_01
alter database default temporary tablespace temp_group
select * from database_properties
where upper(PROPERTY_NAME) like '%DEFAULT%'
page revision: 4, last edited: 08 May 2009 05:20