Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Are Table Drops Logged?
In article <7bojt8$7bc_at_bgtnsc01.worldnet.att.net>,
"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.
>
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: <-> <-> <-> <-> http://homepage.interaccess.com/~akaplan <-> <-> <-> <-> email: akaplan_at_interaccess.com <-> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-> -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your OwnReceived on Fri Mar 05 1999 - 15:44:50 CST