VIEW: MDSYS.ALL_SDO_GEOM_METADATA

Source

View Text - Preformatted

SELECT  b.SDO_OWNER OWNER,
        b.SDO_TABLE_NAME TABLE_NAME,
        b.SDO_COLUMN_NAME COLUMN_NAME,
        b.SDO_DIMINFO DIMINFO,
        b.SDO_SRID SRID
FROM mdsys.SDO_GEOM_METADATA_TABLE b,
     all_objects a
WHERE  b.sdo_table_name = a.object_name
  AND  b.sdo_owner = a.owner
  AND  a.object_type in ('TABLE', 'SYNONYM', 'VIEW')

View Text - HTML Formatted

SELECT B.SDO_OWNER OWNER
, B.SDO_TABLE_NAME TABLE_NAME
, B.SDO_COLUMN_NAME COLUMN_NAME
, B.SDO_DIMINFO DIMINFO
, B.SDO_SRID SRID FROM MDSYS.SDO_GEOM_METADATA_TABLE B
, ALL_OBJECTS A WHERE B.SDO_TABLE_NAME = A.OBJECT_NAME
AND B.SDO_OWNER = A.OWNER
AND A.OBJECT_TYPE IN ('TABLE'
, 'SYNONYM'
, 'VIEW')