Is dropping
table logged?
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.
Ans:
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.