Re: rescue table help

From: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 22 May 2001 08:43:28 +1000
Message-ID: <3b099a24@news.iprimus.com.au>

He could of course use Log Miner whether he is in archivelog mode or not, provided that the online logs haven't switched around in the meantime, and over-written the relevant redo entries.

Regards
HJR

--
=============================!!=============================
The views expressed are my own only, and definitely NOT those of Oracle
Corporation
=============================!!=============================


"John Darrah" <jdarrah_at_veripost.net> wrote in message
news:9BAAB192E5938F448EDF31E326507DD2095357_at_DENS600...


> I don't know why enterprise manager would still be showing 11,000 rows.

 It


> could be that it is looking at the stats on the table which don't get

> updated until the table is analyzed.  Analyze the table and see if the

> num_rows column changes.  As far as recovering the table goes, if you are

 on


> 8.1.X and in archive log mode, you can use logmnr to generate an undo

> statement for the delete.  See the docs on logminer for details

>

> Good Luck

>

> --

> Posted from [63.83.225.245]

> via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Mon May 21 2001 - 17:43:28 CDT