2016年
-
编辑 删除
客户在做impdp时，报“ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'”
昨天快下班时，客户在QQ上发来信息，说在做impdp测试时，一直报ORA-30036,undotbs表空间不足，查了一下，找到两个相关的文章：735366.1 - Run Out Of Space On Undo Tablespace Using Import/Export DataPump727894.1 - Import Data Pump Exhausts Undo Tablespace - ORA-30036CauseExcess undo generation can occur when there is a Primary Key (PK) constraint present on the system. Import datapump will perform index maintenance and this can increase undo usage especially if there is other DML occurring on the database
