반응형
Default Tablespace Type
select * from DATABASE_PROPERTIES
where property_name='DEFAULT_TBS_TYPE'
;
AWS RDS for Oracle 생성 후 생성된 Tablespace 목록
select ddf.tablespace_name, ddf.file_name, round(ddf.bytes/1024/1024,2) MB, ddf.autoextensible, ddf.increment_by, dts.bigfile
from dba_data_files ddf, dba_tablespaces dts
where ddf.tablespace_name = dts.tablespace_name
;
Big Tablespace와 Small Tablespace 생성
--기본값이 Bigfile인 관계로 Bigfile로 생성
CREATE TABLESPACE bigfiletest1 DATAFILE SIZE 1G AUTOEXTEND ON MAXSIZE 10G ;
CREATE BIGFILE TABLESPACE bigfiletest2 DATAFILE SIZE 1G AUTOEXTEND ON MAXSIZE 10G ;
--Smallfile을 명시하면 Smallfile로 생성 됨
CREATE SMALLFILE TABLESPACE smaillfiletest2 DATAFILE SIZE 1G AUTOEXTEND ON MAXSIZE 10G ;
select ddf.tablespace_name, ddf.file_name, round(ddf.bytes/1024/1024,2) MB, ddf.autoextensible, ddf.increment_by, dts.bigfile
from dba_data_files ddf, dba_tablespaces dts
where ddf.tablespace_name = dts.tablespace_name
;
Default Tablespace Type을 Small file로 변경 (안됨)
alter database set default SMALLFILE tablespace;
반응형