This discussion is archived
2 Replies Latest reply: Jun 28, 2011 11:49 AM by mtefft RSS

OWM versus Flashback Data Archive (Oracle Total Recall)

mtefft Journeyer
Currently Being Moderated
Can anyone suggest a resource that compares the capabilities of Oracle Workspace Manager versus Oracle Total Recall?
We are particularly interested in change tracking, but an assessment of other capabilities would also be helpful.

Thanks.
  • 1. Re: OWM versus Flashback Data Archive (Oracle Total Recall)
    Ben Speckhard Pro
    Currently Being Moderated
    Hi,

    I am not aware of any such document that directly compares these 2 products. Are you looking for some information in particular regarding Workspace Manager?

    Regards,
    Ben
  • 2. Re: OWM versus Flashback Data Archive (Oracle Total Recall)
    mtefft Journeyer
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points