[Oracle] 테이블스페이스의 생성 및 크기변경

CREATE TABLESPACE EMS_IDX DATAFILE
'C:/oraclexe/oradata/XE/EMS_IDX.dbf' size 128M
DEFAULT STORAGE (
INITIAL 100K
NEXT 100K
PCTINCREASE 0
MINEXTENTS 1
);

ALTER DATABASE DATAFILE
'C:/oraclexe/oradata/XE/EMS_COMN_IDX01.DBF' RESIZE 128M;

ALTER TABLESPACE APLUS_DATA_TS ADD DATAFILE '/data/oradata/data/aplus_data_ts_1.dbf' SIZE 100M AUTOEXTEND OFF;

SQL> ALTER DATABASE DATAFILE '/data/oradata/data/aplus_data_ts_1.dbf'
  2  AUTOEXTEND ON
  3  NEXT 100M
  4  MAXSIZE UNLIMITED;