ORA-30036:unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
出现问题原因:
大批量导入某表时imp报错如下:
Export file created by EXPORT:V11.02.00 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
import server uses WE8MSWIN1252 character set (possible charset conversion)
.....
IMP-00058: ORACLE error 30036 encountered
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
IMP-00028: partial import of previous table rolled back: 814416 rows rolled back
IMP-00057: Warning: Dump file may not contain data of all partitions of this table
Import terminated successfully with warnings.
字面意思翻译就是:无法按8扩展字段
首先了解了一下UNDO的作用:
1.什么是还原表空间?
还原表空间即Undo表空间,是Oracle特有的概念,Undo表空间会自动分配Undo段,用来保存事务中DML( Insert、Update或Delete)语句的Undo数据。在Orac
oracle 关于“ORA-30036”处理方法
最新推荐文章于 2021-04-09 12:39:18 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)