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;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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