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


TABLE: GSMADMIN_INTERNAL.REGION

Object Details
Object Name: REGION
Object Type: TABLE
Owner: GSMADMIN_INTERNAL
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: SYS_C00246447
  1. ColumnNAME
Unique Key: NUM_UNIQUE
  1. ColumnNUM
Indexes
Index Type Uniqueness Tablespace Column
NUM_UNIQUE NORMAL UNIQUE TablespaceSYSAUX ColumnNUM
SYS_C00246447 NORMAL UNIQUE TablespaceSYSAUX ColumnNAME
Foreign Keys
Table
Foreign Table Foreign Key Column
REGION SYS_C00246449 TableREGION REGION BUDDY_REGION
TableDATABASE SYS_C00246477 REGION DATABASE REGION_NUM
TableGSM SYS_C00246458 REGION GSM REGION_NUM
TableREGION SYS_C00246449 REGION REGION BUDDY_REGION
Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (30) Yes
NUM NUMBER
Yes
BUDDY_REGION NUMBER

CHANGE_STATE CHAR (1)
WEIGHTS VARCHAR2 (500)
Query Text

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


SELECT NAME
,      NUM
,      BUDDY_REGION
,      CHANGE_STATE
,      WEIGHTS
FROM GSMADMIN_INTERNAL.REGION;

Dependencies

[top of page]

GSMADMIN_INTERNAL.REGION does not reference any database object

GSMADMIN_INTERNAL.REGION is referenced by following:

SchemaGSMADMIN_INTERNAL
Package BodyDBMS_GSM_CLOUDADMIN - show dependent code
Package BodyDBMS_GSM_POOLADMIN - show dependent code
Package BodyDBMS_GSM_UTILITY - show dependent code