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

Object Details

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

Internal table for tracking potential target databases for templates.

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: TEMPLATE$_TARGETS_PK

TEMPLATE_TARGET_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
REPCAT$_TEMPLATE_TARGETS_U1	NORMAL	UNIQUE	SYSTEM	TARGET_DATABASE
TEMPLATE$_TARGETS_PK	NORMAL	UNIQUE	SYSTEM	TEMPLATE_TARGET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TEMPLATE_TARGET_ID	NUMBER		Yes	Internal primary key of the template targets table.
TARGET_DATABASE	VARCHAR2	(128)	Yes	Global identifier of the target database.
TARGET_COMMENT	VARCHAR2	(2000)		Comment on the target database.
CONNECT_STRING	VARCHAR2	(4000)		The connection descriptor used to connect to the target database.
SPARE1	VARCHAR2	(4000)		The spare column

Query Text

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


SELECT TEMPLATE_TARGET_ID
,      TARGET_DATABASE
,      TARGET_COMMENT
,      CONNECT_STRING
,      SPARE1
FROM SYSTEM.REPCAT$_TEMPLATE_TARGETS;

Dependencies

[top of page]

SYSTEM.REPCAT$_TEMPLATE_TARGETS does not reference any database object

SYSTEM.REPCAT$_TEMPLATE_TARGETS is referenced by following:

SYS: DBA_TEMPLATE_TARGETS