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: APPLSYS.FND_TNS_ALIAS_DESCRIPTIONS

Object Details

Object Name:	FND_TNS_ALIAS_DESCRIPTIONS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_TNS_ALIAS_DESCRIPTIONS
Subobject Name:
Status:	VALID

A TNS Alias will have a description list that contains one or more connection descriptions. The FND_TNS_ALIAS_DESCRIPTIONS table contains information needed to construct the descriptions for a given alias

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_TNS_ALIAS_DESCRIPTIONS_U1	NORMAL	UNIQUE	APPS_TS_SEED	TNS_ALIAS_DESCRIPTION_GUID
FND_TNS_ALIAS_DESCRIPTIONS_U2	NORMAL	UNIQUE	APPS_TS_SEED	TNS_ALIAS_GUID SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
TNS_ALIAS_DESCRIPTION_GUID	RAW	(16)	Yes	Unique ID for this row
TNS_ALIAS_GUID	RAW	(16)	Yes	Key into fnd_tns_aliases
SEQUENCE_NUMBER	NUMBER		Yes	Determines order in the alias description list
FAILOVER	VARCHAR2	(10)		ON or OFF. Controls clinet-side connection failover
LOAD_BALANCE	VARCHAR2	(10)		ON or OFF. Controls client-side (i.e random) connection load balancing across the addresses in the address list
DB_SERVICE_GUID	RAW	(16)		Database Service id
DB_INSTANCE_GUID	RAW	(16)		Database Instance id
CREATION_DATE	DATE		Yes	Standard who column for Apps
CREATED_BY	NUMBER		Yes	Standard who column for Apps
LAST_UPDATE_DATE	DATE		Yes	Standard who column for Apps
LAST_UPDATED_BY	NUMBER		Yes	Standard who column for Apps
LAST_UPDATE_LOGIN	NUMBER			Standard who column
SERVICE_NAME	VARCHAR2	(255)		Service Name
INSTANCE_NAME	VARCHAR2	(16)		Instance name

Query Text

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


SELECT TNS_ALIAS_DESCRIPTION_GUID
,      TNS_ALIAS_GUID
,      SEQUENCE_NUMBER
,      FAILOVER
,      LOAD_BALANCE
,      DB_SERVICE_GUID
,      DB_INSTANCE_GUID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SERVICE_NAME
,      INSTANCE_NAME
FROM APPLSYS.FND_TNS_ALIAS_DESCRIPTIONS;

Dependencies

[top of page]

APPLSYS.FND_TNS_ALIAS_DESCRIPTIONS does not reference any database object

APPLSYS.FND_TNS_ALIAS_DESCRIPTIONS is referenced by following:

APPS: FND_TNS_ALIAS_DESCRIPTIONS