最近数据量不断增加,其中有一个表已经10G大小了,在导入数据的时候报以下错误 ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDOTBS01' 我把它从UNDOTBS01 =4G大小,在增加一个表空间UNDOTBS02=30G大小,导入大量的数据时候正常。今天早上导入数据时候又不正常了,还是报ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDOTBS02' 现在又给它增加了20G了,才能把数据导入。这样增加下去也不是办法,求救各位大大
最近数据量不断增加,其中有一个表已经10G大小了,在导入数据的时候报以下错误 ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDOTBS01' 我把它从UNDOTBS01 =4G大小,在增加一个表空间UNDOTBS02=30G大小,导入大量的数据时候正常。今天早上导入数据时候又不正常了,还是报ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDOTBS02' 现在又给它增加了20G了,才能把数据导入。这样增加下去也不是办法,求救各位大大
Cause: the specified undo tablespace has no more space available.
Action: Add more space to the undo tablespace before retrying the operation. An alternative is to wait until active transactions to commit.