There is a known issue with Oracle where the flashback logs are not reclaimable when a PDB is dropped and a restore point exists in the PDB.
I can see a restore point in x$kccrsp but no restore points exist in v$restore_point. I believe I am experiencing the aforementioned issue but the Oracle support web site is "experiencing an unscheduled outage" and I was wondering if anyone knows of a solution for removing the errant restore point.
Asked by Jim D
(570 rep)
Apr 7, 2024, 03:54 AM
Last activity: Jul 23, 2025, 04:06 AM
Last activity: Jul 23, 2025, 04:06 AM