Database Administration (MOSC)

MOSC Banner

How to view dml in logmnr?

Oracle Database 19.3 Enterprise edition

SELECT OPERATION, STATUS, SQL_REDO FROM V$LOGMNR_CONTENTS WHERE USERNAME = 'MYUSER';

I see my ddl: create table test (tcol number);

But I do NOT see my dml: insert into test values(123);

Supplemental logging is turned on:

SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;

YES

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