Hi,

I've been looking over ON & Metalink with no luck, We have to
restore some data and are looking through the logs. But the changes
took place via a stored procedure using passed parameters and it looks
like the parameters are not resolved in the logs. Are we SOL? Or is
there another way.

Wish RMAN did table level restores.

Thanks!

On Jan 13, 1:07*pm, The Magnet <a... (AT) unsu (DOT) com> wrote:

Where Log Miner is documented depends on your release. See Oracle
support document How to Setup LogMiner #111886.1 for help.

Oracle8i Administrator's Guide, Release 8.1.6
Oracle8i Administrator's Guide, Release 8.1.7
Oracle9i Database Administrator's Guide Release 2 (9.2)
Oracle® Database Utilities 10g Release 1 (10.1)
Oracle® Database Utilities 10g Release 2 (10.2)
Oracle® Database Utilities 11g Release 1 (11.1)

While the actual procedure parameters may not be part of the redo log
the DML executed by the procedure will be. Log Miner will generate
the SQL necessary to backout each change.

HTH -- Mark D Powell --

On Jan 14, 9:53*am, Mark D Powell <Mark.Powe... (AT) hp (DOT) com> wrote:
Read here:


http://oratips-ddf.blogspot.com/2008...-in-mines.html




David Fitzjarrell