목차

DATAFILE

datafile 추가

datafile 삭제

datafile 크기변경(resize)

  1. datafile 용량 변경
    alter database datafile '/home/oracle/oradata/SOAF/01.dbf' resize 100m;
  2. temporary file 용량 변경 
    alter database tempfile '/home/oracle/oradata/SOAF/temp01.dbf' resize 100m;