[Home] [Help] [Dependency Information]
Object Name: | DBA_SUPPLEMENTAL_LOGGING |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Describes the current state of supplemental logging for this database
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MINIMAL | VARCHAR2 | (3) | Is minimal supplemental Logging ON - YES or NO | |
PRIMARY_KEY | VARCHAR2 | (3) | Is primary key supplemental Logging ON - YES or NO | |
UNIQUE_INDEX | VARCHAR2 | (3) | Is unique column supplemental Logging ON - YES or NO | |
FOREIGN_KEY | VARCHAR2 | (3) | Is foreign key supplemental Logging ON - YES or NO | |
ALL_COLUMN | VARCHAR2 | (3) | Is all column supplemental Logging ON - YES or NO | |
PROCEDURAL | VARCHAR2 | (3) | Is supplemental logging for procedural replication ON - YES or NO |
Cut, paste (and edit) the following text to query this object:
SELECT MINIMAL
, PRIMARY_KEY
, UNIQUE_INDEX
, FOREIGN_KEY
, ALL_COLUMN
, PROCEDURAL
FROM SYS.DBA_SUPPLEMENTAL_LOGGING;
|
|
|