Home » SQL & PL/SQL » SQL & PL/SQL » ORA-55617: Flashback Archive (
ORA-55617: Flashback Archive [message #575832] Mon, 28 January 2013 05:02 Go to next message
Messages: 132
Registered: November 2011
Senior Member
I am getting below error when i am running my application

ORA-55617: Flashback Archive "XXXXX" runs out of space and tracking on "XXXX"

I googled and found
Flashback archive tablespace quota is running out.
Suggested solution:
Add tablespace or increase tablespace quota for the flashback archive.

Mine is a development box, i don't need Flashback archive, please explain me how to disable this
I have tried
SQL> alter flashback archive ANDO remove tablespace users;
alter flashback archive ANDO remove tablespace users
ERROR at line 1:
ORA-55626: Cannot remove the Flashback Archive's primary tablespace

Re: ORA-55617: Flashback Archive [message #575836 is a reply to message #575832] Mon, 28 January 2013 05:32 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Drop the flashback archive itself.

Previous Topic: simple Shell Script - howto do the same in PL/SQL
Next Topic: PL/SQL Anonymous block
Goto Forum:

Current Time: Sun Aug 20 23:51:23 CDT 2017

Total time taken to generate the page: 0.13102 seconds