Home » SQL & PL/SQL » SQL & PL/SQL » ORA-55617: Flashback Archive (11.2.0.3.0)
ORA-55617: Flashback Archive [message #575832] Mon, 28 January 2013 05:02 Go to next message
rishwinger
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
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

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: 57648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Drop the flashback archive itself.

Regards
Michel
Previous Topic: BULK INSERT PERFORMANCE
Next Topic: ult_http
Goto Forum:
  


Current Time: Thu Apr 24 13:29:04 CDT 2014

Total time taken to generate the page: 0.24645 seconds