[Home] [Help] [Dependency Information]

TABLE: GSMADMIN_INTERNAL.SERVICE_PREFERRED_AVAILABLE

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: SYS_C00278405

1. SERVICE_NAME
2. POOL_NAME
3. DATABASE

Unique Key: SYS_C00278406

1. SYS_NC0000800009$

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00278405	NORMAL	UNIQUE	SYSAUX	SERVICE_NAME POOL_NAME DATABASE
SYS_C00278406	NORMAL	UNIQUE	SYSAUX	INSTANCES

Foreign Keys

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

Columns

Query Text

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;

Dependencies

[top of page]

GSMADMIN_INTERNAL

DBPARAMS_LIST

DBPARAMS_T

INSTANCE_LIST

SYS

STANDARD - show dependent code

GSMADMIN_INTERNAL

DBMS_GSM_CLOUDADMIN - show dependent code

DBMS_GSM_POOLADMIN - show dependent code