AWS RDS for Oracle 기본 환경

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;