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: SCN doesn't increment after DROP TABLE

Re: SCN doesn't increment after DROP TABLE

From: Mark D Powell <markp7832_at_my-deja.com>
Date: 2000/05/26
Message-ID: <8glu1a$4a6$1@nnrp1.deja.com>#1/1

In article <8gk2nb$qms$1_at_nnrp1.deja.com>,   kal121_at_my-deja.com wrote:
> How come DROP TABLE statements aren't recorded in the archive logs? Or
> rather, why isn't the SCN number incrementing after I do a DROP TABLE?
>
> This information must be recorded somewhere - or else when you do
> recovery, it wouldn't know to drop tables that had been previously
> dropped!
>

Just because Oracle apparently does not update the scn number for a drop table operation does not mean that the DDL has not been recorded in the redo log from which all recovery originates. After all when you drop a table some information is written to rollback and rollback is written to redo and it would be the scn number of the last update to the table that would be important in a recovery to a time prior to the drop.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri May 26 2000 - 00:00:00 CDT

Original text of this message

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