RE: recover table after drop

From: Shreepad Vaidya <Shreepad.Vaidya_at_alltel.com>
Date: Fri, 22 Sep 2000 1:55 -0500
Message-Id: <10626.117627@fatcity.com>

Hi,
I completely agree that a good backup is a must . But anyways try using Logminer facility if you are using Oracle 8.0 and above.

Otherwise ........-:((

                    Hope this helps.
                         Shreepad

From: ORACLE-L_at_fatcity.com AT INTERNET on 09/21/2000 06:40 AM

To: Shreepad Vaidya/IN/ALLTELCORP, ORACLE-L_at_fatcity.com AT

INTERNET_at_CCMAIL
cc:

Subject: RE: recover table after drop

Archived logs are useless if you don't have a good old backup to start from.
I'm afraid you're stuck ... :-(

> ----------
> From: Alexander Ordonez[SMTP:aordonez_at_ccss.sa.cr]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, September 21, 2000 01:16
> To: Multiple recipients of list ORACLE-L
> Subject: recover table after drop
>
>
> > Hi DBA's
> > I need help for recovery table after drop, i don't have backup,
exists
> any
> > forms????
> > only have a archivelog....
> >
> > any idea?????????????
> >
>

---


> >   Lic. Alexander Ord=F3=F1ez Arroyo

> >   Administrador Tru64Unix

> >   Caja Costarricense del Seguro Social

> >   Divisi=F3n de Inform=E1tica  Soporte T=E9cnico

> >   Telefono: 295-2004, San Jos=E9, Costa Rica

> >   Aordonez_at_ccss.sa.cr

> >

> >

>

----------------------------------------------------------------------
---


> --

> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> --

> Author: Alexander Ordonez

>   INET: aordonez_at_ccss.sa.cr

>

> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing

Lists


> --------------------------------------------------------------------

> 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.com
--
Author:
  INET: ddorr.cs_at_clearstream.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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

Received on Fri Sep 22 2000 - 01:55:17 CDT