[Home] [Help] [Dependency Information]
Object Name: | SERVICE_PREFERRED_AVAILABLE |
---|---|
Object Type: | TABLE |
Owner: | GSMADMIN_INTERNAL |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_C00246482 | NORMAL | UNIQUE | SYSAUX |
SERVICE_NAME
POOL_NAME DATABASE |
SYS_C00246483 | NORMAL | UNIQUE | SYSAUX | INSTANCES |
Table | |
Foreign Table | Foreign Key Column | SERVICE_PREFERRED_AVAILABLE | DATABASE | SERVICE_PREFERRED_AVAILABLE DATABASE | SERVICE_PREFERRED_AVAILABLE | DATABASE_POOL | SERVICE_PREFERRED_AVAILABLE POOL_NAME | SERVICE_PREFERRED_AVAILABLE | SERVICE |
SERVICE_PREFERRED_AVAILABLE
SERVICE_NAME
SERVICE_PREFERRED_AVAILABLE POOL_NAME |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SERVICE_NAME | VARCHAR2 | (64) | Yes | |
POOL_NAME | VARCHAR2 | (30) | Yes | |
DATABASE | VARCHAR2 | (30) | Yes | |
PREFERRED | NUMBER | (1) | ||
STATUS | CHAR | (1) | ||
STATE | CHAR | (1) | ||
DBPARAMS | DBPARAMS_LIST | (1457) | ||
INSTANCES | INSTANCE_LIST | (16) | ||
CHANGE_STATE | CHAR | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT SERVICE_NAME
, POOL_NAME
, DATABASE
, PREFERRED
, STATUS
, STATE
, DBPARAMS
, INSTANCES
, CHANGE_STATE
FROM GSMADMIN_INTERNAL.SERVICE_PREFERRED_AVAILABLE;
|
|
|