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


TABLE: MST.MST_MD_HYDROS

Object Details
Object Name: MST_MD_HYDROS
Object Type: TABLE
Owner: MST
Subobject Name:
Status: VALID


N


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000329581C00012$$ LOB UNIQUE TablespaceAPPS_TS_SEED
SYS_IL0000329581C00013$$ LOB UNIQUE TablespaceAPPS_TS_SEED
MST_MD_HYDROS_N1 DOMAIN NONUNIQUE Tablespace ColumnGEOMETRY
Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (70)
Defines the name of the hydrography entity.
HYDROGRAPHY_ID NUMBER

The HYDROGRAPHY ID defines the unique identifier of the entity.
FEATURE_CODE NUMBER

The FEATURE CODE defines the type of hydrography.
INST_STYLE_ID NUMBER

Generic unique identifier for an entity.
AREA NUMBER

Defines the surface in square units.
GEOMETRY SDO_GEOMETRY (1)
Query Text

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


SELECT NAME
,      HYDROGRAPHY_ID
,      FEATURE_CODE
,      INST_STYLE_ID
,      AREA
,      GEOMETRY
FROM MST.MST_MD_HYDROS;

Dependencies

[top of page]

MST.MST_MD_HYDROS references the following:

SchemaMDSYS
TYPESDO_ELEM_INFO_ARRAY
TYPESDO_GEOMETRY
TYPESDO_ORDINATE_ARRAY
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
MST.MST_MD_HYDROS is referenced by following:

SchemaAPPS
SynonymMST_MD_HYDROS