DBA Data[Home] [Help] [Dependency Information]

TABLE: IEB.IEB_GROUP_PLAN_MAPS

Object Details
Object Name: IEB_GROUP_PLAN_MAPS
Object Type: TABLE
Owner: IEB
Subobject Name:
Status: VALID


Maps server groups to service plans.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IEB_GROUP_PLAN_MAPS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMAP_ID
IEB_GROUP_PLANS_MAPS_U2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSERVER_GROUP_ID
IEB_GROUP_PLAN_MAPS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSERVICE_PLAN_ID
Columns
Name Datatype Length Mandatory Comments
MAP_ID NUMBER (15) Yes Map ID
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
SERVICE_PLAN_ID NUMBER (15) Yes Service Plan ID
SERVER_GROUP_ID NUMBER (15) Yes Server Group ID
SECURITY_GROUP_ID NUMBER (15)
This column is the subscriber?s unique ID that enables secure and exclusive data access for Application Hosting Support.
OBJECT_VERSION_NUMBER NUMBER

Sequential number used for database locking control when usinging HTML as a user interface.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MAP_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SERVICE_PLAN_ID
,      SERVER_GROUP_ID
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM IEB.IEB_GROUP_PLAN_MAPS;

Dependencies

[top of page]

IEB.IEB_GROUP_PLAN_MAPS does not reference any database object

IEB.IEB_GROUP_PLAN_MAPS is referenced by following:

SchemaAPPS
SynonymIEB_GROUP_PLAN_MAPS