ORA-04043: object object_name does not exist
Error:
Getting following error while dropping the USER.
SQL> drop user SCOTT cascade;
drop user SCOTT cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04043: object /38a33ae9_SALESvAL does not exist
Cause
Check the following object in dba_object table.
SElect object_name,object_type from dba_objects
Note: You can check object type which object need to create and check similar object related to value got.
Solution
1. Create the object temporary in the database.
Note: this issue generally occurrs from TYPE object so i used type object in example.
create type "/38a33ae9_SALESval" as object (empno number);
2. Then try to drop the user.
Drop user scott cascade;