Oracle Database Discussions

alter table Schema.table no flashback archive...Hangs

This command will run but Oracle is taking a very long time to actually remove the table
from Total Recall or even it hangs for 4-5 days.
You can query dba_flashback_archive_tables and it will still the table is there


When we tried to re-issue the ALTER TABLE command to disable flashback archive,

we got ORA-55602: The table "Schema.Table" is not enabled for
Flashback Archive.


If you try to re-enable the table for Total Recall you get an error

ORA-55624: The table "string"."string" cannot be enabled for Flashback Archive at this point
Cause: An attempt was made to enable Flashback Archive again on a table which was just disabled.
Action: Try again later.

Again suggesting that a process is falling behind and just needs to catch up.

I Guess FlashBack Database Archive (FBDA) process is slow writing to the system tables....
and if thats not finished we cant disable the recall...Can we make this process fast

Have anyone encountered this before....


Thanks in Advance
Gagan