Wednesday, September 17, 2008

DBA_MVIEW_LOG_FILTER_COLS

DBA_MVIEW_LOG_FILTER_COLS lists all columns (excluding primary key columns) being logged in the materialized view 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

Column being logged

Oracle data dictionary views

Oracle dynamic performance views

No comments:

Post a Comment