Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, spur230.

Asked: September 13, 2016 - 9:31 pm UTC

Last updated: September 14, 2016 - 3:56 pm UTC

Version: 12.1.0.2

Viewed 1000+ times

You Asked

For lower environment , we obfuscate data by updating. Before obfuscation, I want to turn off flashback archive so that it tablespace would not run out of space.

How do I turn off flashback archive and turn it back again?

Thanks.

and Connor said...

Check out the disassociate/reassociate routines

https://docs.oracle.com/cd/E18283_01/appdev.112/e16760/d_flashb_archive.htm


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Clarify your requiremet...

Mike, September 14, 2016 - 11:49 am UTC

The disassociate/reassociate will retain your history.
If you want the history to go away, use
ALTER TABLE xxx NO FLASHBACK ARCHIVE;
(You need ADMINISTER FLASHBACK ARCHIVE privileges for this)

then start collecting history again with
ALTER TABLE xxx FLASHBACK ARCHIVE yyy;


Chris Saxon
September 14, 2016 - 3:56 pm UTC

Good point. Also note that disassociate/reassociate has a significant health warning in the docs:

Oracle cannot endorse compliance history of a table after the table is disassociated. Disassociating a table should only be done after consulting with Oracle Support.

http://docs.oracle.com/database/121/ARPLS/d_flashb_archive.htm#ARPLS72465

Chris
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.