ORA-30036 的错误解决

最新推荐文章于 2024-11-28 09:17:16 发布

转载最新推荐文章于 2024-11-28 09:17:16 发布 · 4.3k 阅读

数据库专栏收录该内容

29 篇文章

订阅专栏

本文介绍了当尝试删除Oracle数据库中某条记录时遇到ORA-30036错误的情况及解决方案。该错误通常是因为撤销表空间无法扩展导致。文中通过检查数据文件大小及其自动扩展属性来诊断问题，并演示了如何通过调整数据文件大小来解决这一问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

There is not enough space left either due to the datafiles being full, autoextend which is not set at datafile level or due to a disk which's full.

You'll have to check the size of the datafiles attached to the undo tablespace and check whether they can autoextend or not..

SQL> delete from data where sid=41;
delete from data where sid=41
*
ERROR at line 1:
ORA-30036: unable to extend segment by 128 in undo tablespace 'UNDOTBS1'

SQL> select file_name, bytes, autoextensible, maxbytes from dba_data_files where tablespace_name='UNDOTBS1';

FILE_NAME
--------------------------------------------------------------------------------
BYTES AUTOEX MAXBYTES
---------- ------ ----------
/home/oracle/oradata/depsight/undotbs1.dbf

SQL> alter database datafile '/home/oracle/oradata/depsight/undotbs1.dbf' resize 50m;

Database altered.

SQL> select file_name, bytes, autoextensible, maxbytes from dba_data_files where tablespace_name='UNDOTBS1';

FILE_NAME
--------------------------------------------------------------------------------
BYTES AUTOEX MAXBYTES
---------- ------ ----------
/home/oracle/oradata/depsight/undotbs1.dbf
52428800 NO 0

SQL> delete from data where sid=41;
delete from data where sid=41

导入的时候请用commit=y