테이블 스페이스를 튜닝하려고 아래 명령어를 입력하였다.
ALTER TABLESPACE 테이블스페이스명 AUTOEXTEND ON NEXT 1024K;
그랬더니 아래처럼 오류가 떨어졌다.
ORA-32773: operation not supported for smallfile tablespace 테이블스페이스명
구글링해서 얻어온 해결책 하나. 아래 경우를 살펴보기 바란다.
SQL> alter tablespace users resize 300m;
alter tablespace users resize 300m
*
ERROR at line 1:
ORA-32773: operation not supported for smallfile tablespace USERS
SQL> select file_id, tablespace_name from dba_data_files;
FILE_ID TABLESPACE_NAME
---------- ------------------------------
1 SYSTEM
2 UNDOTBS1
3 SYSAUX
4 USERS
SQL> alter database datafile 4 resize 300m;
Database altered.
//--------Description from online documents------------------------------------------------------------------
ORA-32773: operation not supported for smallfile tablespace string
Cause: An attempt was made to perform. an operation which is supported only for bigfile tablespaces, e.g. resize tablespace.
Action: Use the appropriate clause of the ALTER DATABASE DATAFILE command instead.
SQL> alter tablespace users autoextend off;
alter tablespace users autoextend off
*
ERROR at line 1:
ORA-32773: operation not supported for smallfile tablespace USERS
SQL> alter database datafile 4 autoextend off;
Database altered.