[Home] [Help] [Dependency Information]
Object Name: | SERVICE |
---|---|
Object Type: | TABLE |
Owner: | GSMADMIN_INTERNAL |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_C00246480 | NORMAL | UNIQUE | SYSAUX |
NAME
POOL_NAME |
Table | |
Foreign Table | Foreign Key Column | SERVICE | DATABASE_POOL | SERVICE POOL_NAME | SERVICE_PREFERRED_AVAILABLE | SERVICE |
SERVICE_PREFERRED_AVAILABLE
SERVICE_NAME
SERVICE_PREFERRED_AVAILABLE POOL_NAME |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (64) | Yes | |
NETWORK_NAME | VARCHAR2 | (250) | Yes | |
POOL_NAME | VARCHAR2 | (30) | Yes | |
STATUS | CHAR | (1) | ||
PREFERRED_ALL | NUMBER | (1) | ||
LOCALITY | NUMBER | (1) | ||
REGION_FAILOVER | NUMBER | (1) | ||
ROLE | NUMBER | (1) | ||
FAILOVER_PRIMARY | NUMBER | (1) | ||
ANY_LAG | NUMBER | (1) | ||
LAG | NUMBER | |||
RUNTIME_BALANCE | NUMBER | (1) | ||
LOAD_BALANCE | NUMBER | (1) | ||
NOTIFICATION | NUMBER | (1) | ||
TAFPOLICY | NUMBER | (1) | ||
POLICY | NUMBER | (1) | ||
DTP | NUMBER | (1) | ||
FAILOVER_METHOD | VARCHAR2 | (6) | ||
FAILOVER_TYPE | VARCHAR2 | (12) | ||
FAILOVER_RETRIES | NUMBER | |||
FAILOVER_DELAY | NUMBER | |||
EDITION | VARCHAR2 | (30) | ||
PDB | VARCHAR2 | (30) | ||
COMMIT_OUTCOME | NUMBER | |||
RETENTION_TIMEOUT | NUMBER | |||
REPLAY_INITIATION_TIMEOUT | NUMBER | |||
SESSION_STATE_CONSISTENCY | VARCHAR2 | (7) | ||
SQL_TRANSLATION_PROFILE | VARCHAR2 | (30) | ||
CHANGE_STATE | CHAR | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT NAME
, NETWORK_NAME
, POOL_NAME
, STATUS
, PREFERRED_ALL
, LOCALITY
, REGION_FAILOVER
, ROLE
, FAILOVER_PRIMARY
, ANY_LAG
, LAG
, RUNTIME_BALANCE
, LOAD_BALANCE
, NOTIFICATION
, TAFPOLICY
, POLICY
, DTP
, FAILOVER_METHOD
, FAILOVER_TYPE
, FAILOVER_RETRIES
, FAILOVER_DELAY
, EDITION
, PDB
, COMMIT_OUTCOME
, RETENTION_TIMEOUT
, REPLAY_INITIATION_TIMEOUT
, SESSION_STATE_CONSISTENCY
, SQL_TRANSLATION_PROFILE
, CHANGE_STATE
FROM GSMADMIN_INTERNAL.SERVICE;
GSMADMIN_INTERNAL.SERVICE does not reference any database object
GSMADMIN_INTERNAL.SERVICE is referenced by following:
|
|
|