ORA-32773

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>

至此问题已经解决。