oracle 表空间快满了，加空间报错ORA-02142: missing or invalid ALTER TABLESPACE... - 重庆思庄Oracle、Redhat认证学习论坛

QQ图片20220623132927.png (9.29 KB, 下载次数: 234)

2022-6-23 13:29 上传

输入sql语句发现报错：
SQL> alter tablespace datafile '/u01/app/oracle/oradata/orcl/heamonitor/heamon.dbf' resize 2048M;
alter tablespace datafile '/u01/app/oracle/oradata/orcl/heamonitor/heamon.dbf' resize 2048M
*
ERROR at line 1:
ORA-02142: missing or invalid ALTER TABLESPACE option

SQL> alter tablespace heamon datafile '/u01/app/oracle/oradata/orcl/heamonitor/heamon.dbf' resize 2g;
alter tablespace heamon datafile '/u01/app/oracle/oradata/orcl/heamonitor/heamon.dbf' resize 2g
*
ERROR at line 1:
ORA-02142: missing or invalid ALTER TABLESPACE option

还是一样报错，最后输入：
SQL> alter database datafile '/u01/app/oracle/oradata/orcl/heamonitor/heamon.dbf' resize 2g;

Database altered.

成功调整空间。

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)