ORA-30015: previously offlined undo tablespace 'string' is still pending

ORA-30015: previously offlined undo tablespace 'string' is still pending
Cause: the current operation is not allowed because an undo tablespace containing active transactions is pending from a previous SWITCH UNDO operation. The operation will be allowed again after all transactions in the previous undo tablespace are committed.
Action: Wait for all previous transactions to commit before reissuing the current statement.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-30015：以前离线的undo表空间' string '仍然待处理,
.原因：不允许当前操作，因为包含活动事务的撤销表空间从前一个SWITCH UNDO操作处于挂起状态。在提交之前的undo表空间中的所有事务之后，将再次允许该操作。,
.操作：等待所有先前的事务提交，然后重新发布当前语句。,
.

aiaiDBA

13718043309

010-86462881

ORA-30015: previously offlined undo tablespace 'string' is still pending

1 个回答

相似问题