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$_KEY_COLUMNS

Object Details

Object Name:	REPCAT$_KEY_COLUMNS
Object Type:	TABLE
Owner:	SYSTEM
Subobject Name:
Status:	VALID

Primary columns for a table using column-level replication

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: REPCAT$_KEY_COLUMNS_PRIMARY

SNAME
ONAME
COL

Indexes

Index	Type	Uniqueness	Tablespace	Column
REPCAT$_KEY_COLUMNS_PRIMARY	NORMAL	UNIQUE	SYSTEM	SNAME ONAME COL
REPCAT$_KEY_COLUMNS_PRNT_IDX	NORMAL	NONUNIQUE	SYSTEM	SNAME ONAME TYPE

Foreign Keys

Table		Foreign Table	Foreign Key Column
REPCAT$_KEY_COLUMNS		REPCAT$_REPOBJECT	REPCAT$_KEY_COLUMNS SNAME REPCAT$_KEY_COLUMNS ONAME REPCAT$_KEY_COLUMNS TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
SNAME	VARCHAR2	(128)	Yes	Schema containing table
ONAME	VARCHAR2	(128)	Yes	Name of the table
TYPE	NUMBER			Type identifier
COL	VARCHAR2	(128)	Yes	Column in the table

Query Text

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


SELECT SNAME
,      ONAME
,      TYPE
,      COL
FROM SYSTEM.REPCAT$_KEY_COLUMNS;

Dependencies

[top of page]

SYSTEM.REPCAT$_KEY_COLUMNS does not reference any database object

SYSTEM.REPCAT$_KEY_COLUMNS is referenced by following:

SYS: DBA_REPKEY_COLUMNS; DBMS_REPCAT_FLA - show dependent code; DBMS_REPCAT_MAS - show dependent code; DBMS_REPCAT_OBJ_UTL - show dependent code; DBMS_REPCAT_UTL - show dependent code; DBMS_REPCAT_UTL3 - show dependent code