테이블 스페이스 생성

SELECT 'create tablespace ' || TABLESPACE_NAME || ' datafile ''' || FILE_NAME || ''' size ' || BYTES || ' AUTOEXTEND ON NEXT 10485760'

       || ' LOGGING'

       || ' ONLINE'

       || ' PERMANENT'

       || ' EXTENT MANAGEMENT LOCAL AUTOALLOCATE'

       || ';' as table_space

FROM

  (

  SELECT E.TABLESPACE_NAME,E.FILE_NAME,E.BYTES, (E.BYTES-SUM(F.BYTES)) RESULT

  FROM DBA_DATA_FILES E, DBA_FREE_SPACE F

  WHERE E.FILE_ID = F.FILE_ID

  GROUP BY E.TABLESPACE_NAME, E.FILE_NAME, E.BYTES

  ) A;

 

CREATE TABLESPACE CRMS DATAFILE

'c:\Tibero\tibero6\database\DATA\CRMS1.dtf' SIZE 10485760 AUTOEXTEND ON NEXT 10485760

LOGGING

ONLINE

PERMANENT

EXTENT MANAGEMENT LOCAL AUTOALLOCATE

;

 

CREATE TABLESPACE CRMS_IDX DATAFILE

'c:\Tibero\tibero6\database\DATA\CRMS_IDX.dtf' SIZE 10485760 AUTOEXTEND ON NEXT 10485760

LOGGING

ONLINE

PERMANENT

EXTENT MANAGEMENT LOCAL AUTOALLOCATE

;

 

--데이터 파일 추가

ALTER TABLESPACE CRMS

ADD DATAFILE 'c:\tibero_data\CRMS_TBL2.dbf' size 2147614720;   

 

테이블 스페이스 삭제

DROP TABLESPACE [Tablespace Name]

INCLUDING CONTENTS AND DATAFILES

CASCADE CONSTRAINTS;

 

DROP TABLESPACE CRMS INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;