Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Flashback Archive can't be dropped

Rapid E-SuiteMar 16 2011 — edited Sep 21 2011

The developer here has started using FBDA on our 11gR2 (11.2.0.1) database and then we had encountered the high CPU issue then we decided to upgrade database to 11.2.0.2. Once the upgrade complete, everything seems fine except I can't drop some old flash back archive and its tablespaces that were created before upgrade.

I used "drop flashback xxx;" then the result is "flashback ARCHIVE dropped." but this flashback archive still exist on dba_flashback_archive, sys_fba_trackedtables and sys_fba_fa and I can't drop tablespace due to this error.

SQL Error: ORA-55641: Cannot drop tablespace used by Flashback Data Archive

Any suggestions are appreciate.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 19 2011

Added on Mar 16 2011

#11g, #general-database-discussions

15 comments

1,498 views