As per article, query is as per below:
SELECT OWNER, NAME, TYPE FROM DBA_DEPENDENCIES WHERE REFERENCED_OWNER='MDSYS' AND REFERENCED_NA
ME = 'ST_GEOMETRY' AND REFERENCED_TYPE = 'TYPE' AND TYPE='TABLE';
Please run the above query as it is using "sys" login. This may help.
Thanks,
Biraja