Thanks for the question, Divya.
Asked: May 12, 2020 - 6:34 am UTC
Last updated: May 12, 2020 - 10:30 am UTC
Version: 12c
Viewed 1000+ times
You Asked
Wanted to do a clean test on Flashback Data Archive so had to remove the existing.
I disabled FDA on all enabled tables and dropped FDA. All commands executed successfully.
But still i see the record in DBA_FLASHBACK_ARCHIVE And DBA_FLASHBACK_ARCHIVE_TS
If i attempt to drop the tablespace, i get "ora-55641 cannot drop tablespace used by flashback data archive". When i drop FDA its successful and no errors.
I tried alter flashback data archive purge and i still could not drop TS. -> alter flashback archive fla1 purge all;
Then i tried to alter FDA and see if i can delink - alter flashback archive fla1 remove tablespace tbs2; -> I get the error "ORA-55626: Cannot remove the Flashback Archive's primary tablespace"
Can i know if any internal tables has to be cleaned.
and Chris said...
I'm not sure exactly what you're doing here. A complete example showing all the statements ran would help!
Note that many of the flashback archive commands are asynchronous. You issue the statement, the database queues, and return OK. But actually carrying out your command may still fail!
If you're running into difficulties with this I suggest contacting support.
Is this answer out of date? If it is, please let us know via a Comment