Re: Undelete records

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 2 Jul 2001 12:07:41 +0100
Message-ID: <3b4055ff$0$3755$ed9e5944@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.

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 - 06:07:41 CDT