Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SCN doesn't increment after DROP TABLE
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
![]() |
![]() |