ORA-4043

Text:   object <name> does not exist
-------------------------------------------------------------------------------
Cause:  An object name was specified that was not recognized by the system.
        There are several possible causes:
        An invalid name for a table, view, sequence, procedure, function,
        package, or package body was entered.
        Since the system did not recognize the invalid name, it responded with
        the message that the named object did not exist.
        An attempt was made to rename an index or a cluster or some other
        object that cannot be renamed.
Action: Check the spelling of the renamed object and rerun the code.
        Valid names of tables, views, functions, and so forth can be listed by
        querying the data dictionary.

 

 

package안의 synonyms의 사용 시 부모 object가 사라져서 발생하는 에러일수도 있다

 

1. 문제의 synonym 확인
예) ora-04043 : object SYS_PLSQL_337779_26_2 does not exist 일경우

 

select owner,object_name,object_type
from dba_objects
where object_name like 'SYS_PLSQL@_337779_@_%'' escape '@'
order by object_name;

 

2. 모든 synonym 삭제