ORA-01086: savepoint ‘B‘ never established in this session or is invalid

喝醉酒的小白

于 2022-05-21 16:20:28 发布

阅读量1.6k

点赞数

CC 4.0 BY-SA版权

分类专栏： DBA 文章标签：数据库

本文链接：https://blog.csdn.net/hezuijiudexiaobai/article/details/124899729

DBA 专栏收录该内容

986 篇文章

订阅专栏

本文介绍了数据库事务中的SAVEPOINT概念，它允许在事务中设置多个回滚点。当需要部分撤销事务更改时，可以利用SAVEPOINT来回到之前的状态。文章详细解释了SAVEPOINT的使用方法和其在回滚操作中的作用，同时也提到了错误情况如尝试回滚未建立或无效的保存点时的错误信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SAVEPOINT ： Use the SAVEPOINT statement to identify a point in a transaction to which you can later roll back.
在这里插入图片描述
原因：通过创建检查点我们可以在事务提交前回退到任意已创建检查点的事务。检查点在事务提交后就不存在了。

01086, 00000, "savepoint '%s' never established in this session or is invalid"
// *Cause:  An attempt was made to roll back to a savepoint that was never
//          established in this session, or was invalid.
// *Action: Try rolling back to the savepoint from the session where it is established.