Database Utilities (MOSC)

MOSC Banner

Total recall / flashback data archive

edited Dec 14, 2012 10:27PM in Database Utilities (MOSC) 1 commentAnswered
 I have been trying to investigate how total recall (TR) /flashback data archive works and it seems hard to find good documentation about it. Sure, I find lots about how to set it up but nothing that answers questions like:

- How do statistics work on a TR table ? Do you need to run special stats on these tables?

- Does the normal table indexes also work on the historic data?

- How does a partitioned table work with TR? Is the archived data partitioned too?

- If you create a materialized view on a TR table, does it also create all the history on that table?

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