ORA-32773问题的解决方法。
Tags: ora-32773 oracle
由于数据库表空间不够用，并且为非自动扩展，需要扩展表空间
SQL> alter tablespace TTAPPS autoextend on next 50m maxsize 1000m;
alter tablespace TTAPPS autoextend on next 50m maxsize 1000m
*
ERROR at line 1:
ORA-32773: operation not supported for smallfile tablespace TTAPPS
产生此问题的原因是不能对表空间自动扩展，要对数据文件扩展，概念理解错误。
SQL> alter datafile ttapps01.dbf autoextend on next 50m maxsize 1000m
2 ;
alter datafile ttapps01.dbf autoextend on next 50m maxsize 1000m
*
ERROR at line 1:
ORA-00940: invalid ALTER command 缺少database关键字
SQL> alter database datafile ttapps01.dbf autoextend on next 50m maxsize 1000m;
alter database datafile ttapps01.dbf autoextend on next 50m maxsize 1000m
*
ERROR at line 1:
ORA-02236: invalid file name 文件名错误
SQL> alter database datafile “/home2/ttdatafile/ttapps01.dbf” autoextend on next 50m maxsize 1000m;
alter database datafile “/home2/ttdatafile/ttapps01.dbf” autoextend on next 50m maxsize 1000m
*
ERROR at line 1:
ORA-02236: invalid file name 文件名应该用单引号。
SQL> alter database datafile ‘/home2/ttdatafile/ttapps01.dbf’ autoextend on;
Database altered.
SQL> alter database datafile ‘/home2/ttdatafile/ttapps01.dbf’ autoextend off;
Database altered.
SQL> alter database datafile ‘/home2/ttdatafile/ttapps01.dbf’ autoextend on next 50m maxsize 1000m
2 ;
Database altered.
SQL>
至此问题已经解决。