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