Data Dictionary Views, 104 of 112

DBA_SNAPSHOT_LOG_FILTER_COLS

DBA_SNAPSHOT_LOG_FILTER_COLS lists all filter columns (excluding primary key columns) being logged in the snapshot logs.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the master table being logged.

NAME

VARCHAR2(30)

NOT NULL

Name of the master table being logged.

COLUMN_NAME

VARCHAR2(30)

NOT NULL

Filter column being logged.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the master table being logged.
`NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the master table being logged.
`COLUMN_NAME`	`VARCHAR2(30)`	`NOT NULL`	Filter column being logged.