Using the My Oracle Support Portal (MOSC)

MOSC Banner

Why logminer v$logmnr_contents.sql_redo does not use PK fields only for delete operation, even when

edited Oct 24, 2018 5:02AM in Using the My Oracle Support Portal (MOSC) 1 commentAnswered

ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS is applied.

For a table update DML, v$logmnr_contents.sql_redo where clause uses table PK fields only => good

Yet for a delete DML, the sql_redo where clause uses all table fields : why ???

As bad effect, If one table field is of type "long", such sql_redo can't be applied because of "ORA-00997: illegal use of LONG datatype"...

Some idea ?

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center