eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: SYSTEM.REPCAT$_AUDIT_COLUMN

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: REPCAT$_AUDIT_COLUMN_PK

COLUMN_NAME
ONAME
SNAME

Indexes

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

Foreign Keys

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

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_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

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_ID
,      BASE_REFERENCE_NAME
,      ATTRIBUTE
FROM SYSTEM.REPCAT$_AUDIT_COLUMN;

Dependencies

[top of page]

SYSTEM.REPCAT$_AUDIT_COLUMN does not reference any database object

SYSTEM.REPCAT$_AUDIT_COLUMN is referenced by following:

SYS: ALL_REPAUDIT_COLUMN; DBA_REPAUDIT_COLUMN; DBMS_DEFERGEN_AUDIT - show dependent code; DBMS_DEFERGEN_RESOLUTION - show dependent code; DBMS_REPCAT_CONF - show dependent code; DBMS_REPCAT_SNA_UTL - show dependent code; DBMS_REPCAT_UTL - show dependent code; USER_REPAUDIT_COLUMN