DML missing from LogMiner results (Oracle 12c)
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.