今天就跟大家聊聊有关ORA-32773: operation not supported for smallfile tablespace USERS错误该怎么解决，可能很多人都不太了解，为了让大家更加了解，小编给大家总结了以下内容，希望大家根据这篇文章可以有所收获。
错误描述：
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.
看完上述内容，你们对ORA-32773: operation not supported for smallfile tablespace USERS错误该怎么解决有进一步的了解吗？如果还想了解更多知识或者相关内容，请关注云搜网行业资讯频道，感谢大家的支持。
