OraFAQ Forum: SQL & PL/SQL » ORA-55617: Flashback Archive

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-55617: Flashback Archive (11.2.0.3.0)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

ORA-55617: Flashback Archive [message #575832]

Mon, 28 January 2013 05:02

rishwinger
Messages: 104
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
Cause:
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

Report message to a moderator