[Home] [Help] [Dependency Information]
Object Name: | FND_TNS_LISTENERS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_TNS_LISTENERS |
Subobject Name: | |
Status: | VALID |
The FND_TNS_LISTENERS table tracks the TNS Listeners used on a system to contact a databases and RPC services.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_TNS_LISTENERS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | LISTENER_GUID |
FND_TNS_LISTENERS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
SERVER_GUID
LISTENER_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LISTENER_GUID | RAW | (16) | Yes | Unique ID for this row, since the unique key Host+Port may change. (In particular, the port may change.) |
LISTENER_NAME | VARCHAR2 | (255) | Yes | Each listener has a name, however, this is not forced to be unique outside of an ORACLE_HOME. In fact, AutoConfig will name all Apps RPC listeners in a given system the same: "APPS_%s_dbsid%". So, listener_name should not be used as a key |
CREATED_BY | NUMBER | Yes | Standard "who" column | |
CREATION_DATE | DATE | Yes | Standard "who" column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard "who" column | |
LAST_UPDATE_DATE | DATE | Yes | Standard "who" column | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard "who" column | |
SERVER_GUID | RAW | (16) | Yes | SERVER_GUID |
TNS_ALIAS_GUID | RAW | (16) | TNS_ALIAS_GUID |
Cut, paste (and edit) the following text to query this object:
SELECT LISTENER_GUID
, LISTENER_NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SERVER_GUID
, TNS_ALIAS_GUID
FROM APPLSYS.FND_TNS_LISTENERS;
APPLSYS.FND_TNS_LISTENERS does not reference any database object
APPLSYS.FND_TNS_LISTENERS is referenced by following:
|
|
|