[오라클]테이블 스페이스 생성

CREATE TABLESPACE 테이블스페이스명 DATAFILE
'테이블스페이스명' SIZE 2048M AUTOEXTEND ON NEXT 4M MAXSIZE UNLIMITED
LOGGING
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON; 

 

>> 크기 2G, 2G 초과시 4M 씩 자동확장

 

 

 

(ex. CREATE TABLESPACE TS_TEST DATAFILE
'TS_TEST' SIZE 2048M AUTOEXTEND ON NEXT 4M MAXSIZE UNLIMITED
LOGGING
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON;  )