Re: Replay of Log Miner SQL_UNDO fails with ORA-00001

  • From: Rich J <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 20 Oct 2017 09:20:35 -0500

On 2017/10/20 09:00, Reen, Elizabeth wrote:

Did you go back one log too many?   Or does the log have some after the time 
info?  I would get rid of the data after that record as it is probably dups.

Hmmm...even if I did go back one log too many, the failure point is less
than half-way (SQLs were sorted by SCN descending), so it's still
"undoing" DML that was done much more recently. 

Thanks!
Rich

Other related posts: