How to limit logging with conditional supplemental log groups
Greetings,
We're wanting to exclude columns from supplemental logging to prevent a log mining application from mining PII data columns.
We thought that creating a log group excluding those columns would work, which it does if the excluded column is not updated, but
it is available for logging if that column is updated.
Does anyone know of a work-around for this?
Here's a test we did:
Column DUMMY is excluded from the log group:
desc teststm
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
DUMMY VARCHAR2(1)
TESTCOL VARCHAR2(20)
TESTCOL2 VARCHAR2(20)
TESTPK NOT NULL VARCHAR2(20)
>list
1 select substr(LOG_GROUP_NAME,1,33), substr(TABLE_NAME,1,33), substr(COLUMN_NAME,1,33)