Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Are Table Drops Logged?
Hi Julia,
yes it is, but you have to know the exact time when the table was
dropped. Then you can do a "point in time recovery" just before this
moment. To see, when a table is dropped, you have to turn on Orcale
auditing. There you can define which actions have to be logged. But
take care about setting accounting to high. It can very fast fill up
your aud$ table.
Hope it helps
Carlo
"Julia Cristina Varela de Montoya" <jc_va_at_hotmail.com> wrote:
>When a table is dropped, is that happening logged in the redo logs so to
>restore to this point in time? We are on version 7.3.4 by the way.
>
>Many many thanks.
>
>
Received on Fri Mar 05 1999 - 11:02:02 CST