Database Administration (MOSC)

MOSC Banner

DML missing from LogMiner results (Oracle 12c)

edited Mar 5, 2014 12:58AM in Database Administration (MOSC) 3 commentsAnswered ✓

Hello,

I am trying to view all DML against a table called  'incidents' inside a PDB called 'oem'.

However, I am only seeing DDL against the table and no DML.

Am I missing something?  Here are some steps to reproduce:

# connect to the 'oem'  PDB, then run some DDL:

SQL> sho con_name

CON_NAME

------------------------------

CDB$ROOT

SQL> ALTER SESSION SET container=oem;

SQL> ALTER TABLE incidents ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

# now run some DML:

SQL> select * from incidents;

      I_ID SUBJECT

---------- ------------------------------

         5 b

         1 a

SQL> update incidents set i_id = 6 where i_id = 5;

1 row updated.

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