This content has been marked as final. Show 2 replies
Here are some examples of why I am asking this question...
I can use both to track data changes that have been applied to a table, to identify all changes between two points in time.
I can use both to query a table as of some point in the past.
If this is all I am doing, then performance is probably much, much better with Flashback Data Archive.
Some functional differences:
With OWM I can have 'multiple versions of reality' by using child workspaces. With Flashback Data Archive I can not.
With OWM I can 'hold on to' changes in a workspace indefinitely, and discard them if desired.