ORA-30026: Undo tablespace 'string' has unexpired undo with string(sec) left, Undo_Retention=string(sec)

ORA-30026: Undo tablespace 'string' has unexpired undo with string(sec) left, Undo_Retention=string(sec)
Cause: Tried to drop a tablespace that contains unexpired undo information
Action: lower setting of UNDO_RETENTION or wait a while before reissue command to drop undo tablespace

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-30026：撤消表空间' 字符串 '有未过期的撤消与字符串（秒）左，Undo_Retention = 字符串（秒）,
.原因：试图删除包含未到期的撤销信息的表空间,
.操作：降低UNDO_RETENTION的设置或等待一段时间，然后reissue命令删除撤消表空间,
.

aiaiDBA

13718043309

010-86462881

ORA-30026: Undo tablespace 'string' has unexpired undo with string(sec) left, Undo_Retention=string(sec)

1 个回答

相似问题