Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Mailing Lists ->
Oracle-L ->
RE: recover table after drop
RE: recover table after drop
Yes Dear
As Vaidya said first and last resort is logminer
Rao.K.K
- Shreepad Vaidya <Shreepad.Vaidya_at_alltel.com>
wrote:
>
>
> 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
>
>
>
>
> To: Shreepad Vaidya/IN/ALLTELCORP,
> ORACLE-L_at_fatcity.com AT
> INTERNET_at_CCMAIL
> cc:
>
>
>
> 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 Ordsqez Arroyo
> > > Administrador Tru64Unix
> > > Caja Costarricense del Seguro Social
> > > Divisisn de Informatica Soporte Ticnico
> > > Telefono: 295-2004, San Josi, 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
> also send the HELP command for other information
> (like subscribing).
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Shreepad Vaidya
> INET: Shreepad.Vaidya_at_alltel.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
> also send the HELP command for other information
> (like subscribing).
Received on Fri Sep 22 2000 - 03:17:43 CDT
Original text of this message