[Home] [Help]
[Dependency Information]
TABLE: MDSYS.SDO_GEOM_METADATA_TABLE
Object Details
Object Name: | SDO_GEOM_METADATA_TABLE |
Object Type: | TABLE |
Owner: | MDSYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSTEM |
PCT Free: | 10 |
PCT Used: | 40 |
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
SDO_GEOM_IDX
|
NORMAL
|
NONUNIQUE
|
SYSTEM
|
SDO_OWNER
SDO_TABLE_NAME
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
SDO_OWNER |
VARCHAR2 |
(32) |
|
|
SDO_TABLE_NAME |
VARCHAR2 |
(32) |
|
|
SDO_COLUMN_NAME |
VARCHAR2 |
(1024) |
|
|
SDO_DIMINFO |
SDO_DIM_ARRAY |
(583) |
|
|
SDO_SRID |
NUMBER |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT SDO_OWNER
, SDO_TABLE_NAME
, SDO_COLUMN_NAME
, SDO_DIMINFO
, SDO_SRID
FROM MDSYS.SDO_GEOM_METADATA_TABLE;
Dependencies
[top of page]
MDSYS.SDO_GEOM_METADATA_TABLE references the following:
-
MDSYS
-
SDO_DIM_ARRAY
-
SYS
-
STANDARD
- show dependent code
MDSYS.SDO_GEOM_METADATA_TABLE is referenced by following:
-
MDSYS
-
ALL_SDO_GEOM_METADATA
-
CHK_SDO_DIMNAME
-
SDO_GEOM_METADATA_UPDATE
-
SDO_META
- show dependent code
-
SDO_TOPO_METADATA_INT
- show dependent code
-
USER_SDO_GEOM_METADATA