[Home] [Help] [Dependency Information]
Object Name: | REPCAT$_AUDIT_COLUMN |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Information about columns in all shadow tables for all replicated tables in the database
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
REPCAT$_AUDIT_COLUMN_PK | NORMAL | UNIQUE | SYSTEM |
COLUMN_NAME
ONAME SNAME |
REPCAT$_AUDIT_COLUMN_F1_IDX | NORMAL | NONUNIQUE | SYSTEM | ATTRIBUTE |
REPCAT$_AUDIT_COLUMN_IDX1 | NORMAL | NONUNIQUE | SYSTEM |
BASE_SNAME
BASE_ONAME BASE_CONFLICT_TYPE_ID BASE_REFERENCE_NAME |
Table | |
Foreign Table | Foreign Key Column | REPCAT$_AUDIT_COLUMN | REPCAT$_AUDIT_ATTRIBUTE | REPCAT$_AUDIT_COLUMN ATTRIBUTE | REPCAT$_AUDIT_COLUMN | REPCAT$_CONFLICT |
REPCAT$_AUDIT_COLUMN
BASE_SNAME
REPCAT$_AUDIT_COLUMN BASE_ONAME REPCAT$_AUDIT_COLUMN BASE_CONFLICT_TYPE_ID REPCAT$_AUDIT_COLUMN BASE_REFERENCE_NAME |
---|
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_ID | NUMBER | Yes | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT SNAME
, ONAME
, COLUMN_NAME
, BASE_SNAME
, BASE_ONAME
, BASE_CONFLICT_TYPE_ID
, BASE_REFERENCE_NAME
, ATTRIBUTE
FROM SYSTEM.REPCAT$_AUDIT_COLUMN;
SYSTEM.REPCAT$_AUDIT_COLUMN does not reference any database object
SYSTEM.REPCAT$_AUDIT_COLUMN is referenced by following:
|
|
|