Database Administration (MOSC)

MOSC Banner

cannot drop flashback archive

edited Dec 17, 2017 8:00AM in Database Administration (MOSC) 4 commentsAnswered

I cannot seem to drop a flashback archive, even when i get a success message.

SQL> select * from dba_flashback_archive;

OWNER_NAME FLASHBACK_ARCHI FLASHBACK_ARCHI RETENTION_IN_DA CREATE_TIME     LAST_PURGE_TIME                     STATUS

---------- --------------- --------------- --------------- --------------- ----------------------------------- -------

KYWILS     PERM_FDA                      2               7                 08-DEC-17 08.34.11.000000000 AM    

KYWILS     FDA_ARCH_1DAY                 1               1                 15-DEC-17 09.22.52.000000000 AM    

SQL> drop flashback archive FDA_ARCH_1DAY;

Done

SQL> select * from dba_flashback_archive;

OWNER_NAME FLASHBACK_ARCHI FLASHBACK_ARCHI RETENTION_IN_DA CREATE_TIME     LAST_PURGE_TIME                     STATUS

---------- --------------- --------------- --------------- --------------- ----------------------------------- -------

KYWILS     PERM_FDA                      2               7                 08-DEC-17 08.34.11.000000000 AM    

KYWILS     FDA_ARCH_1DAY                 1               1                 15-DEC-17 09.22.52.000000000 AM    

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center