Oracle-L: Re:RE: Undelete Record

From: <dgoulet_at_vicr.com>
Date: Fri, 20 Dec 2002 06:58:57 -0800
Message-ID: <F001.0051FA7F.20021220065857@fatcity.com>

If you have no idea when the data was deleted then your completely out of luck. Bad answer I know, but without that little piece of information it's a needle in several haystacks on several farms type of problem. End of conversation.

Dick Goulet

____________________Reply Separator____________________
Author: =?iso-8859-1?q?Stephane=20Paquette?= <stephane_paquette_at_yahoo.com>
Date:       12/20/2002 6:28 AM

We're in this situation right now.
A user has delete information and want it back. Problem is that we do not know when it was delete.

I have restore 20 copies (days) of the table via import. Going with logminer would have been difficult since we do not know when the data was changed and we have a lot of redo generation.

Naveen Nahata <naveen_nahata_at_mindtree.com> a écrit : > Use logminer
>
>
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/logminer.
> htm#17869
>
> Regards
> Naveen
>
> -----Original Message-----
> Sent: Friday, December 20, 2002 12:14 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Listers,
>
> I have little problem :
> how to undelete record that we've delete and commit
> so I can restore again
> in my data, thanks a lot.
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Sony kristanto
> INET: Sony_at_polyfincanggih.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Naveen Nahata
> INET: naveen_nahata_at_mindtree.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>

Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant stephane_paquette_at_yahoo.com

Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Stephane=20Paquette?=
  INET: stephane_paquette_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Dec 20 2002 - 08:58:57 CST