Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
ALL_LOG_GROUP_COLUMNS
describes columns that are accessible to the current user and that are specified in log groups.
DBA_LOG_GROUP_COLUMNS
describes all columns in the database that are specified in log groups.
USER_LOG_GROUP_COLUMNS
describes columns that are owned by the current user and that are specified in log groups.
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 in which the log group is defined |
COLUMN_NAME |
VARCHAR2(4000) |
Name of the column or attribute of the object type column specified in the log group definition | |
POSITION |
NUMBER |
Original position of the column or attribute in the definition of the object | |
LOGGING_PROPERTY |
VARCHAR2(6) |
Indicates whether the column or attribute would be supplementally logged (LOG ) or not (NO LOG ) |