1401错误提示:ORA-01401 inserted value too large for columnCause: The value entered is larger than the maximum width defined for the column. Action: Enter a value smaller than the column width or use the MODIFY option with ALTER TABLE to expand the column width. 1562错误提示:ORA-01562 failed to extend rollback segment number stringCause: Failure occurred when trying to extend rollback segment.Action: This is normally followed by another error message that caused the failure. You may take the rollback segment offline to perform maintenance. Use the ALTER ROLLBACK SEGMENT OFFLINE command to take the rollback segment offline.
如果不好用,则再脱机一个。直至好用。
ALTER rollback segment rollbackname offline;
2、增加回滚段数据文件的大小
alter database datafile 'rollbackdatafile' resize 200M;
感谢!