"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 an's Home Page