[Home] [Help] [Dependency Information]
Object Name: | IEM_DB_SERVERS |
---|---|
Object Type: | TABLE |
Owner: | IEM |
FND Design Data: | IEM.IEM_DB_SERVERS |
Subobject Name: | |
Status: | VALID |
This table contains information about various IM instances that eMC needs to connect to. Different IM instances may serve as home sites for different email accounts. Different instances may or may not share a set of IMAPs, SMTPs and eMC servers.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEM_DB_SERVERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | DB_SERVER_ID |
IEM_DB_SERVERS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PORT
HOSTNAME SID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DB_SERVER_ID | NUMBER | (15) | Yes | Sequence generated identifier. |
DB_NAME | VARCHAR2 | (50) | Yes | Arbitrary name. User defined. |
HOSTNAME | VARCHAR2 | (256) | Yes | Named parameter required to connect to the specified instance. |
PORT | NUMBER | (5) | Yes | Named parameter required to connect to the specified instance. |
PROTOCOL | VARCHAR2 | (50) | Yes | Named parameter required to connect to the specified instance. |
SID | VARCHAR2 | (256) | Yes | Named parameter required to connect to the specified instance. |
SERVICE_NAME | VARCHAR2 | (256) | Yes | Named parameter required to connect to the specified instance. |
DB_DESCRIPTION | VARCHAR2 | (400) | User defined text, 5 lines of additional information. | |
SERVER_GROUP_ID | NUMBER | (15) | Yes | Sequence generated index. Foreign key from IEM_SERVER_GROUPS. |
RT_AVAILABILITY | VARCHAR2 | (1) | Yes | This column indicates whether the named instance is currently available or not. |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment for column 1 | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
EMAIL_NODE | VARCHAR2 | (100) | Email Node ID | |
ADMIN_USER | VARCHAR2 | (50) | Administrative user ID | |
ADMIN_PASSWORD | VARCHAR2 | (50) | Administrative user password |
Cut, paste (and edit) the following text to query this object:
SELECT DB_SERVER_ID
, DB_NAME
, HOSTNAME
, PORT
, PROTOCOL
, SID
, SERVICE_NAME
, DB_DESCRIPTION
, SERVER_GROUP_ID
, RT_AVAILABILITY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, EMAIL_NODE
, ADMIN_USER
, ADMIN_PASSWORD
FROM IEM.IEM_DB_SERVERS;
IEM.IEM_DB_SERVERS does not reference any database object
IEM.IEM_DB_SERVERS is referenced by following:
|
|
|