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]

VIEW: SYS.DBA_TEMPLATE_TARGETS

Object Details

Object Name:	DBA_TEMPLATE_TARGETS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Internal table for tracking potential target databases for templates.

[View Source]

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.

Query Text

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


SELECT TEMPLATE_TARGET_ID
,      TARGET_DATABASE
,      TARGET_COMMENT
,      CONNECT_STRING
FROM SYS.DBA_TEMPLATE_TARGETS;

Dependencies

[top of page]

SYS.DBA_TEMPLATE_TARGETS references the following:

SYSTEM: REPCAT$_TEMPLATE_TARGETS

SYS.DBA_TEMPLATE_TARGETS is referenced by following:

PUBLIC: DBA_TEMPLATE_TARGETS