Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Are Table Drops Logged?

Re: Are Table Drops Logged?

From: <akaplan_at_interaccess.com>
Date: Fri, 05 Mar 1999 21:44:50 GMT
Message-ID: <7bpj8g$e94$1@nnrp1.dejanews.com>


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 Own    
Received on Fri Mar 05 1999 - 15:44:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US