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%'