VIEW: MDSYS.USER_SDO_GEOM_METADATA

Source

View Text - Preformatted

SELECT SDO_TABLE_NAME TABLE_NAME,
       SDO_COLUMN_NAME COLUMN_NAME,
       SDO_DIMINFO DIMINFO,
       SDO_SRID SRID
FROM SDO_GEOM_METADATA_TABLE
WHERE  sdo_owner = sys_context('userenv', 'CURRENT_USER')

View Text - HTML Formatted

SELECT SDO_TABLE_NAME TABLE_NAME
, SDO_COLUMN_NAME COLUMN_NAME
, SDO_DIMINFO DIMINFO
, SDO_SRID SRID FROM SDO_GEOM_METADATA_TABLE WHERE SDO_OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')