Name: Find Oracle objects in all schemas

Author: Rob Vonk

Language: Oracle

Description:
Find Oracle objects in all schemas to find out where an object exists in case of ora-00955 error.

Snippet:

select *
from dba_objects
where object_name like 'MY_NAME%'