ORA-32773: operation not supported for smallfile tablespace TOOLS

在扩展表空间的时候报错

QL> alter tablespace tools autoextend on next 1m;
alter tablespace tools autoextend on next 1m
*
ERROR at line 1:
ORA-32773: operation not supported for smallfile tablespace TOOLS

 

[oracle@ocm1 ~]$ oerr ora 32773
32773, 00000, "operation not supported for smallfile tablespace %s"
// *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 database datafile 7 autoextend on;  


Database altered.