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%'
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License