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


VIEW: MDSYS.USER_SDO_GEOM_METADATA

Object Details
Object Name: USER_SDO_GEOM_METADATA
Object Type: VIEW
Owner: MDSYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TABLE_NAME VARCHAR2 (32)
COLUMN_NAME VARCHAR2 (1024)
DIMINFO SDO_DIM_ARRAY (600)
SRID NUMBER

Query Text

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


SELECT TABLE_NAME
,      COLUMN_NAME
,      DIMINFO
,      SRID
FROM MDSYS.USER_SDO_GEOM_METADATA;

Dependencies

[top of page]

MDSYS.USER_SDO_GEOM_METADATA references the following:

SchemaMDSYS
TYPESDO_DIM_ARRAY
TableSDO_GEOM_METADATA_TABLE
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
MDSYS.USER_SDO_GEOM_METADATA is referenced by following:

SchemaMDSYS
Package BodyPRVT_PC - show dependent code
Package BodyPRVT_TIN - show dependent code
Package BodySDOTNPC - show dependent code
Package BodySDO_CSW_PROCESS - show dependent code
TriggerSDO_GEOM_TRIG_DEL1
TriggerSDO_GEOM_TRIG_INS1
TriggerSDO_GEOM_TRIG_UPD1
Package BodySDO_NET - show dependent code
Package BodySDO_WFS_PROCESS - show dependent code
SchemaPUBLIC
SynonymUSER_SDO_GEOM_METADATA