Re: Undelete records

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 2 Jul 2001 20:40:33 +0100
Message-ID: <994102680.29945.1.nnrp-13.9e984b29@news.demon.co.uk>

4) Probably too complex too rush into quickly,

but run up logminer, and get it to extract information about the updates made to that table in the relevant time period - including the necessary UNDO sql statements.

--
Jonathan Lewis

Host to The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

Seminars on getting the best out of Oracle
See http://www.jlcomp.demon.co.uk/seminar.html

Screensaver or Lifesaver: http://www.ud.com
Use spare CPU to assist in cancer research.




Niall Litchfield wrote in message
<3b4055ff$0$3755$ed9e5944_at_reading.news.pipex.net>...


>If you have *not* committed the change then you can rollback the delete. If

>however you have committed then what you can do depends on how you are

>backing up your data.

>

>1. Hot backup.

>

>If this is your situation you can perform an incomplete recovery which will

>recover the database to its state prior to the delete

>

>2,. Cold backup.

>

>you can only recover to you last good backup.

>

>Of course there is also option 3 rekey the data <g>

>

>HTH

>

>

>--

>Niall Litchfield

>Oracle DBA

>Audit Commission UK

>"Stefano Tempesta" <s.tempesta_at_usa.net> wrote in message

>news:9hpdse$c8$1_at_fe2.cs.interbusiness.it...

>> Hi

>> I've got a problem!

>> Accidently I deleted (delete from table_name) a lot of records from my

>> "table_name".

>> I have Oracle 8.1.7

>> I'm not very practice with this database server. Can I recover/undelete

 all


>> these records?

>>

>> Many thanks for your help

>>

>> Stefano

>>

>>

>

>

Received on Mon Jul 02 2001 - 14:40:33 CDT