oracle ora00940,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>

至此问题已经解决。