ORA-01640: cannot make tablespace read-only with changes by in-doubt transactions

ORA-01640: cannot make tablespace read-only with changes by in-doubt transactions
Cause: An attempt was made to alter a tablespace read-only while there were changes in the tablespace made by in-doubt distributed transactions. The in-doubt transactions must commit or rollback to ensure that there is no undo for a tablespace before it can be made read-only.
Action: Any in-doubt transactions that made changes to the tablespace must be resolved.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:37

ORA-01640：不能使表空间是只读的，有不确定事务的更改,
.原因：尝试在由不确定分布式事务所做的表空间中发生更改时尝试更改只读表空间。不确定事务必须提交或回滚以确保表空间不存在撤消，然后才能使其为只读。,
.操作：必须解决对表空间进行更改的任何不确定事务。,
.

aiaiDBA

13718043309

010-86462881

ORA-01640: cannot make tablespace read-only with changes by in-doubt transactions

1 个回答

相似问题