VIEW: MDSYS.ALL_SDO_GEOR_SYSDATA

Source

View Text - Preformatted

SELECT SDO_OWNER                 OWNER,
       GEORASTER_TABLE_NAME      TABLE_NAME,
       GEORASTER_COLUMN_NAME     COLUMN_NAME,
       GEOR_METADATA_COLUMN_NAME METADATA_COLUMN_NAME,
       RDT_TABLE_NAME            RDT_TABLE_NAME,
       RASTER_ID                 RASTER_ID,
       OTHER_TABLE_NAMES         OTHER_TABLE_NAMES
FROM SDO_GEOR_SYSDATA_TABLE
WHERE
(
    (sdo_owner = sys_context('userenv', 'CURRENT_USER'))
    or
    exists
    (
     select table_name from all_tables
     where table_name=georaster_table_name
     and owner = sdo_owner
     union all
     select table_name from all_object_tables
     where table_name=georaster_table_name
     and owner = sdo_owner
     union all
     select view_name table_name from all_views
     where  view_name=georaster_table_name
     and owner = sdo_owner
     )
)

View Text - HTML Formatted

SELECT SDO_OWNER OWNER
, GEORASTER_TABLE_NAME TABLE_NAME
, GEORASTER_COLUMN_NAME COLUMN_NAME
, GEOR_METADATA_COLUMN_NAME METADATA_COLUMN_NAME
, RDT_TABLE_NAME RDT_TABLE_NAME
, RASTER_ID RASTER_ID
, OTHER_TABLE_NAMES OTHER_TABLE_NAMES FROM SDO_GEOR_SYSDATA_TABLE WHERE ( (SDO_OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')) OR EXISTS ( SELECT TABLE_NAME
FROM ALL_TABLES
WHERE TABLE_NAME=GEORASTER_TABLE_NAME
AND OWNER = SDO_OWNER UNION ALL SELECT TABLE_NAME
FROM ALL_OBJECT_TABLES
WHERE TABLE_NAME=GEORASTER_TABLE_NAME
AND OWNER = SDO_OWNER UNION ALL SELECT VIEW_NAME TABLE_NAME
FROM ALL_VIEWS
WHERE VIEW_NAME=GEORASTER_TABLE_NAME
AND OWNER = SDO_OWNER ) )