DBA Data[Home] [Help] [Dependency Information]


VIEW: SYS.DBA_REPAUDIT_COLUMN

Object Details
Object Name: DBA_REPAUDIT_COLUMN
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Information about columns in all shadow tables for all replicated tables in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
SNAME VARCHAR2 (128) Yes Owner of the shadow table
ONAME VARCHAR2 (128) Yes Name of the shadow table
COLUMN_NAME VARCHAR2 (128) Yes Name of the column in the shadow table
BASE_SNAME VARCHAR2 (128) Yes Owner of replicated table
BASE_ONAME VARCHAR2 (128) Yes Name of the replicated table
BASE_CONFLICT_TYPE VARCHAR2 (10)
Type of conflict
BASE_REFERENCE_NAME VARCHAR2 (128) Yes Table name, unique constraint name, or column group name
ATTRIBUTE VARCHAR2 (128) Yes Description of the attribute
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SNAME
,      ONAME
,      COLUMN_NAME
,      BASE_SNAME
,      BASE_ONAME
,      BASE_CONFLICT_TYPE
,      BASE_REFERENCE_NAME
,      ATTRIBUTE
FROM SYS.DBA_REPAUDIT_COLUMN;

Dependencies

[top of page]

SYS.DBA_REPAUDIT_COLUMN references the following:

SchemaSYSTEM
TableREPCAT$_AUDIT_COLUMN
SYS.DBA_REPAUDIT_COLUMN is referenced by following:

SchemaPUBLIC
SynonymDBA_REPAUDIT_COLUMN