ORA-04043: object object_name does not exist

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;

This entry was posted in Oracle on by .

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.