▷ Oracle datafile resize and turn autoextend off (오라클 데이터파일 리사이즈)

[ Oracle datafile resize ]
[ turn autoextend off ]

1) datafile
alter database  datafile '/oracle/oradata/XE/system01.dbf' resize 2000M;
alter database  datafile '/oracle/oradata/XE/system02.dbf' resize 2000M;
alter database  datafile '/oracle/oradata/XE/system01.dbf' autoextend off;

2) tempfile
alter database  tempfile '/oracle/oradata/XE/temp01.dbf' resize 1000M;
alter database  tempfile '/oracle/oradata/XE/temp01.dbf' autoextend off;