ORA-30036 的错误解决
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..
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'
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
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
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
所有发生在我们身上的事件都是一个经过仔细包装的礼物。只要我们愿意面对它有时候有点丑恶的包装,带着耐心和勇气一点一点的拆开包装的话,我们会惊喜的看到里面珍藏的礼物。
----遇见未知的自己