Home » SQL & PL/SQL » SQL & PL/SQL » Need data after a transaction
Need data after a transaction [message #194614] Sat, 23 September 2006 00:49 Go to next message
muthuprasad
Messages: 5
Registered: September 2006
Location: Chennai
Junior Member
Hai
I need to get data that is modified after a transaction is completed. i.e if a rollback is made then i need to get original data. since i can't do this with trigger which doesn't response for rollback. is there any possibility. plz help me.
It is urgent
Thanks in advance
Re: Need data after a transaction [message #194637 is a reply to message #194614] Sat, 23 September 2006 05:03 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
No, after a transaction is rolled back, the data of the rolled back transaction can not be obtained.
If the transaction is committed than, its data is available to all.
Re: Need data after a transaction [message #194683 is a reply to message #194637] Sat, 23 September 2006 23:52 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
What exactly do you want to do with the data? Maybe seeing your requirements gives us some ideas.
Need data after a transaction [message #194718 is a reply to message #194614] Sun, 24 September 2006 23:45 Go to previous messageGo to next message
muthuprasad
Messages: 5
Registered: September 2006
Location: Chennai
Junior Member
first of all Thank for your reply

what i want is to take data backup from current DB server to another DB server. how can i get data that is stored or modified in a table.
plz help me.
Re: Need data after a transaction [message #194738 is a reply to message #194718] Mon, 25 September 2006 01:01 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
First of all, Oracle provides several ways to mirror databases.
Secondly, if a transaction ends in a rollback, there is no need to change anything in your shadow-database. You can consider the rolled-back transaction as though it never happened.
Need data after a transaction [message #194987 is a reply to message #194614] Tue, 26 September 2006 07:48 Go to previous messageGo to next message
muthuprasad
Messages: 5
Registered: September 2006
Location: Chennai
Junior Member
Thanks for your replies

You told about Oracle provides several ways to mirror databases can you tell me what are they.
Need data after a transaction [message #194997 is a reply to message #194614] Tue, 26 September 2006 08:09 Go to previous messageGo to next message
muthuprasad
Messages: 5
Registered: September 2006
Location: Chennai
Junior Member
First let me tell my process. Actually i need to take immediate data backup after inserting or modifing data in a table.Actually i used triggers but it is not affected by rollback. so how could i get those data. plz tell me
Re: Need data after a transaction [message #194999 is a reply to message #194997] Tue, 26 September 2006 08:14 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
after a rolback there is by definition NO CHANGE in you data, so there is no need to backup anything!
Re: Need data after a transaction [message #195009 is a reply to message #194614] Tue, 26 September 2006 08:45 Go to previous messageGo to next message
muthuprasad
Messages: 5
Registered: September 2006
Location: Chennai
Junior Member
I need data that is changed during transaction.
Re: Need data after a transaction [message #195011 is a reply to message #195009] Tue, 26 September 2006 08:48 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Unless you have a set of triggers that record the changes to a set of audit tables using autonomous transactions, then there is no way of getting the changes back after a rollback that I know of.

(Thought: Can Log Miner fetch the changes back from the redo logs?)
Re: Need data after a transaction [message #195111 is a reply to message #195011] Wed, 27 September 2006 02:10 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Either I must be missing something, or this really does not make sense. Why on earth do you want changes logged that are rolled back?
Do you want to record each mistake and typo anyone makes? Why? It should suffice to record the committed changes?
Re: Need data after a transaction [message #195127 is a reply to message #195009] Wed, 27 September 2006 02:33 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Well, if you end a transaction with a rollback, then during that transaction, no data has been changed.
Previous Topic: Function in shell
Next Topic: writing on text file using UTL
Goto Forum:
  


Current Time: Wed Dec 07 12:20:23 CST 2016

Total time taken to generate the page: 0.07420 seconds