Home » SQL & PL/SQL » SQL & PL/SQL » data recovery in oracle
data recovery in oracle [message #238912] Sun, 20 May 2007 23:45 Go to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
I am a sql/pl-sql programmer.I have done commit mistakenly in some table data while updating.How can i recover my previous data.Plz tell me whether DBMS_FLASHBACK package can help me?If it can,then tell me the complete procedure step by step in order to recover the previous data.
Re: data recovery in oracle [message #238923 is a reply to message #238912] Mon, 21 May 2007 00:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle version (4 decimals)?

Regards
Michel
Re: data recovery in oracle [message #238941 is a reply to message #238923] Mon, 21 May 2007 01:05 Go to previous messageGo to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
I am using oracle 10g as my database.

[Updated on: Mon, 21 May 2007 02:05]

Report message to a moderator

Re: data recovery in oracle [message #238948 is a reply to message #238941] Mon, 21 May 2007 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
4 decimals, 4 figures, 4 numbers, FOUR.

Regards
Michel
Re: data recovery in oracle [message #238969 is a reply to message #238948] Mon, 21 May 2007 01:33 Go to previous messageGo to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
I am not getting you.Is there any confusion in my question?
Re: data recovery in oracle [message #238975 is a reply to message #238969] Mon, 21 May 2007 01:39 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Michel would like you to post this:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
Note numbers which distinguish database versions: 10.2.0.1(.0)
Re: data recovery in oracle [message #238985 is a reply to message #238975] Mon, 21 May 2007 02:05 Go to previous messageGo to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Re: data recovery in oracle [message #238988 is a reply to message #238985] Mon, 21 May 2007 02:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Here are the ways to do it in 10g db:
flashback table in 10g
flashback version query in oracle 10g

Regards
Michel
Re: data recovery in oracle [message #238992 is a reply to message #238988] Mon, 21 May 2007 02:45 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Why was it of so utmost importance to know the exact patch-level the OP was on? These are general 10g documents.
Re: data recovery in oracle [message #238998 is a reply to message #238992] Mon, 21 May 2007 03:09 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It was not important here but when I ask a question I expect someone who asks for help answers it correctly and completly. Above all when it is so easy to get.
I even did not read his answer just saw it did not contain what I requested.

For other posts, the patch level is important.

Regards
Michel
Previous Topic: Create a temp table from an existing table
Next Topic: ora-27101 error in windows xp???
Goto Forum:
  


Current Time: Mon Dec 05 19:07:01 CST 2016

Total time taken to generate the page: 0.08500 seconds