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.

Report message to a moderator

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;

Report message to a moderator

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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 14 16:33:36 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.