Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm considering going from Oracle Enterprise Edition (EE) to SE/SE1 but want to retain the flashback database and flashback table features from EE.

Does anyone know how to emulate these features in SE/SE1?

Thanks in advance

share|improve this question

closed as off-topic by RolandoMySQLDBA, Phil, Max Vernon, bluefeet, Michael - sqlbot Dec 11 '13 at 21:49

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – RolandoMySQLDBA, Phil, Max Vernon, bluefeet, Michael - sqlbot
If this question can be reworded to fit the rules in the help center, please edit the question.

maybe you should ask how to emulate the flashback database feature and the flashback table feature in SE/SE1 – miracle173 Dec 12 '13 at 6:24

You could try with replicating you changes to change tables. Dbvisit replicate could be of good value here. See Real-time Oracle data and database replication It is not a free tool but it saves a lot compared to running EE.

share|improve this answer
Backup prior to change and then restore when needed? Of course it isn't very convenient but still a viable option. – Raj Dec 11 '13 at 13:54

Not the answer you're looking for? Browse other questions tagged or ask your own question.