Find Oracle objects in all schemas

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

select *
from dba_objects
where object_name like 'MY_NAME%'