CREATE OR REPLACE PUBLIC SYNONYM COE_CONFIGURATION FOR COE_CONFIGURATION;
CREATE OR REPLACE PUBLIC SYNONYM COE_NAMESPACES FOR COE_NAMESPACES;

owner   object_name          object_type  status
PUBLIC	COE_CONFIGURATION    SYNONYM	VALID
PUBLIC	COE_DOM_HELPER	     SYNONYM	VALID
PUBLIC	COE_NAMESPACES	     SYNONYM	VALID
PUBLIC	COE_TOOLS	     SYNONYM	VALID
PUBLIC	COE_UTILITIES	     SYNONYM	VALID

from DBA_synonyms s
where not exists (select 'x'
                  from DBA_objects o
                  where o.owner = s.table_owner
                  and   o.object_name = s.table_name)
and db_link is null
order by 1, 2;

synonym_owner synonym_name table_owner table_name
PUBLIC	COE_CONFIGURATION	SYS	COE_CONFIGURATION
PUBLIC	COE_DOM_HELPER	        SYS	COE_DOM_HELPER
PUBLIC	COE_NAMESPACES	        SYS	COE_NAMESPACES
PUBLIC	COE_TOOLS	        SYS	COE_TOOLS
PUBLIC	COE_UTILITIES	        SYS	COE_UTILITIES

create table test_t (m number);
Table TEST_T created.

drop table test_t;
Table TEST_T dropped.

SQL> create table test_t (m number);
Table created.

SQL> drop table test_t;
Table dropped.

CREATE OR REPLACE TRIGGER db_ddl_info_object
AFTER DDL ON DATABASE
BEGIN
  DBMS_OUTPUT.PUT_LINE('DB object name is: ' || ora_dict_obj_owner || '.' || ora_dict_obj_name);
END;

SQL> show user
USER is "SYSTEM"

SQL> set serveroutput on
SQL> create table test (v number);
DB object name is: SYSTEM.TEST                                                  

Table created.

SQL> drop table test;
DB object name is: SYSTEM.TEST                                                  

Table dropped.

SQL> show user
USER is "HR"

SQL> set serveroutput on
SQL> create table test_t (m number);
DB object name is: HR.TEST_T                                                    

Table created.

SQL> drop table test_t;
DB object name is: HR.TEST_T                                                    
DB object name is: HR.TEST_T                                                    

Table dropped.

CREATE OR REPLACE TRIGGER db_ddl_info_object
AFTER DDL ON DATABASE
DECLARE
    V_SQL_STMT_LINE_CNT NUMBER;
    V_SQL_STMT_LINE     ORA_NAME_LIST_T;
    v_stmt              VARCHAR2(2000) := '';
BEGIN
    V_SQL_STMT_LINE_CNT := ORA_SQL_TXT(V_SQL_STMT_LINE);
    FOR i IN 1..V_SQL_STMT_LINE_CNT LOOP
      v_stmt := v_stmt || V_SQL_STMT_LINE(i);
    END LOOP;
-- Additional output of DDL text
--    DBMS_OUTPUT.PUT('DDL executed is: ');
--    DBMS_OUTPUT.PUT_LINE(v_stmt);
-- Suppress duplicated trigger output when DDL is DROP (TABLE or INDEX) and RECYCLEBIN is enabled
    if v_stmt NOT LIKE '%RENAME TO "BIN$%' then
      DBMS_OUTPUT.PUT('DB object name is: ');
      if ora_dict_obj_owner IS NOT NULL then
        DBMS_OUTPUT.PUT(ora_dict_obj_owner || '.');
      end if;
      DBMS_OUTPUT.PUT_LINE(ora_dict_obj_name);
    end if;
END;