RE: Replay of Log Miner SQL_UNDO fails with ORA-00001
Date: Fri, 20 Oct 2017 14:00:19 +0000
Message-ID: <258575162B63424EB58DAE3A5475B6ED012CC11134_at_EXNJMB25.nam.nsroot.net>
Liz
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich J
Sent: Friday, October 20, 2017 9:41 AM
To: Oracle L
Subject: Replay of Log Miner SQL_UNDO fails with ORA-00001
Hey all,
In a test 11.2.0.3 NOARCHIVELOG database, a business analyst wants to know what a particular table looked like last week. Flashback query is not enabled, but I do have enough redo logs to contain the transactions since then. So, after verifying via audit trail that there has been no DDL on this table, I fire up Log Miner via Toad and add the inactive redo logs. I then run:
SELECT
scn,
sql_undo
FROM v$logmnr_contents
WHERE seg_name = 'MYTABLE';
FORCE LOGGING is not on, but supplemental logging is. Assuming there has been no DML on this table between the log mining and the SQL replay, am I missing something here? My pre-caffeinated sinus-pressured brain thinking...not...morning...this.......
Thanks!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 20 2017 - 16:00:19 CEST