Re: Recover erased records.

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Wed, 13 Apr 2005 20:49:47 +0200
Message-ID: <425d69cd$0$20684$ba620e4c@news.skynet.be>

"Mª Carmen Lozano" <noriepa_at_teleline.es> wrote in message news:6i77e.816083$q7.1064486_at_telenews.teleline.es...
>I yesterday erased of a table 200 registries by error, would like to know
>that I can do for being able to recover them. If there is some file that
>keeps all the erased information, or daily a backup is made with the
>command cpio of UNIX.
> Can somebody help me?
> Regards,
> Noriepa
>
>

Try this :

INSERT INTO <name of temp table>

(SELECT * FROM <erased table> AS OF TIMESTAMP ('12-APR-05 00:00:00','DD-MON-YY HH24: MI: SS')) Of course this depends on the retention period of your undo tablespace.

Matthias Received on Wed Apr 13 2005 - 13:49:47 CDT