Time and again, we run into the need of checking the list of objects local to our schema. The below scripts will do that for us. We can all more columns from user_objects view to the script if we need more details about the local objects.

set linesize 200
column object_name format a60
column object_type format a40

select object_name,
       object_type
 from  user_objects
/
set linesize 100