TableSpace 조회하고 생성하기

TableSpace 조회

SELECT TABLESPACE_NAME, FILE_NAME, BYTES/1024 AS MBytes, RESULT/1024 AS USE_MBytes 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;

TableSpace File 생성

CREATE TABLESPACE CSCHATUSR_DAT 

      DATAFILE '/gmalltest/GMALLTST/DATA/CSCHARTUSR01.DBF' SIZE 1024M

      AUTOEXTEND ON NEXT 10M MAXSIZE 4096M

      EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;

TableSpace File Size 변경

alter database datafile '/test01/NEWGMALL/DATA/CSCHARTUSR01.DBF' resize 1024M;