ORA-55617解决方法

昨天一测试环境出现异常ORA-55617: Flashback Archive "XXXXX" runs out of space and tracking on "XXXX",其解释如下:

Description: Flashback Archive "string" runs out of space and tracking on "string" is suspended
Cause: Flashback archive tablespace quota is running out.
Action: Add tablespace or increase tablespace quota for the flashback archive.

FBA没有设置配额,理论上应该是无限制才对,实际是用了5GB多之后出现该异常,表空间为自动扩展。所以解释有误,经测试,修改配合后问题解决,如下:

alter flashback archive HD_FDA modify tablespace hd_fbda quota 30g;

原文地址:https://www.cnblogs.com/zhjh256/p/10172007.html