SELECT SDO_OWNER OWNER,
TABLE_NAME,
COLUMN_NAME,
DEP_TABLE_SCHEMA,
DEP_TABLE_NAME
FROM SDO_TIN_PC_SYSDATA_TABLE a
WHERE
(
exists
(
select table_name from all_tables
where table_name=a.table_name
and owner = sdo_owner
union all
select table_name from all_object_tables
where table_name=a.table_name
and owner = sdo_owner
union all
select view_name table_name from all_views
where view_name=a.table_name
and owner = sdo_owner
)
)
SELECT SDO_OWNER OWNER
,
TABLE_NAME
,
COLUMN_NAME
,
DEP_TABLE_SCHEMA
,
DEP_TABLE_NAME
FROM SDO_TIN_PC_SYSDATA_TABLE A
WHERE
(
EXISTS
(
SELECT TABLE_NAME
FROM ALL_TABLES
WHERE TABLE_NAME=A.TABLE_NAME
AND OWNER = SDO_OWNER
UNION ALL
SELECT TABLE_NAME
FROM ALL_OBJECT_TABLES
WHERE TABLE_NAME=A.TABLE_NAME
AND OWNER = SDO_OWNER
UNION ALL
SELECT VIEW_NAME TABLE_NAME
FROM ALL_VIEWS
WHERE VIEW_NAME=A.TABLE_NAME
AND OWNER = SDO_OWNER
)
)
|
|
|