Home » RDBMS Server » Backup & Recovery » flash back mechanisim in session wise?
flash back mechanisim in session wise? [message #221017] Fri, 23 February 2007 04:18 Go to next message
gowthamsen
Messages: 14
Registered: August 2006
Junior Member
Can we implement the flash back mechanisim in session wise?

I mean, for example,
We have taken the scn for the table emp which contains 5 records..
We inserted 2 records in session1. committed.
and we inserted 2 records in session 2. and commited.
Now I would like to do flash back to the prvious sate in session2, without effecting the data in the session 1.
so I display data in emp in session 2, I want to see the 7 records without removing the data inserted in sesssion1.

Can we implement this scenarion?

Thank you,
Regards,

Gowtham Sen.
Re: flash back mechanisim in session wise? [message #226454 is a reply to message #221017] Fri, 23 March 2007 16:30 Go to previous messageGo to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Perhaps datamining would help you find and undo a specific session's commits;
Re: flash back mechanisim in session wise? [message #226456 is a reply to message #221017] Fri, 23 March 2007 16:41 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"Database High Availability Overview", Chapter 2 "Oracle Database High Availability Solutions", section Oracle Flashback Technology

"Database Application Developer's Guide - Fundamentals", Chapter 10 Developing Flashback Applications

Regards
Michel
Previous Topic: Archive Log Directory Filling Up the Oracle Volume
Next Topic: drawbacks of extensive import/export cycles
Goto Forum:
  


Current Time: Thu Dec 08 19:52:02 CST 2016

Total time taken to generate the page: 0.29423 seconds