Recovering data from the log file

[balachandar]

Hi,
Is there any way to recover the data from the log file in Oracle 9i. Some Oracle warehouse builder related data was deleted from Oracle 9i tables. We want to recover the data from the log file. Is there any tool with which we can do it ?

Thanks and Regards
Balachandar Ganesan.

 

[alexhu]

I think you want Log Miner - but there are restrictions to its use - its in the Admin Manual

Alex

 

[Scunningham99]

depends if your log file has been overwritten. How many logfiles have you got, and how many logswitches have occured since transaction.

if you are in archivelog mode this is not an issue as each log is archived off once it is filled.



Sy UK