Database Administration (MOSC)

MOSC Banner

How to limit logging with conditional supplemental log groups

edited May 18, 2020 1:41PM in Database Administration (MOSC) 7 commentsAnswered ✓

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)

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