"Julia Cristina Varela de Montoya" 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.
>
Julia,
Yes, *ALL* DML and DDL, including DROP TABLE is recorded in the redo logs /
archived redo logs. If you restore to a point in time, this information will be
used to restore the database. So, after restoring, your table that was DROPped
will no longer be there.
Best regards,
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 265+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page