DBA_LOG_GROUPS

Oracle 11gR1

DBA_LOG_GROUPS describes log group definitions on all tables in the database.

Related Views

· ALL_LOG_GROUPS describes the log group definitions on the tables accessible to the current user.

· USER_LOG_GROUPS describes the log group definitions on the tables owned by the current user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the log group definition
LOG_GROUP_NAME	VARCHAR2(30)	NOT NULL	Name of the log group definition
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table on which the log group is defined
LOG_GROUP_TYPE	VARCHAR2(19)		Type of the log group: · PRIMARY KEY LOGGING · UNIQUE KEY LOGGING · FOREIGN KEY LOGGING · ALL COLUMN LOGGING · USER LOG GROUP
ALWAYS	VARCHAR2(11)		Y indicates the log group is logged any time a row is updated; N indicates the log group is logged any time a member column is updated.
GENERATED	VARCHAR2(14)		Indicates whether the name of the supplemental log group was system generated (GENERATED NAME) or not (USER NAME)

Oracle data dictionary views