Monday, October 2, 2017

ORA-04043 object XXXXXX does not exist

When I tried to drop my user, I got the error

drop user mrrame cascade;

ORA-00604: error occurred at recursive SQL level 1
ORA-04043: object SYS_PLSQL_816EF5E1_361_1 does not exist

Not sure what is causing it, but quick workaround is to drop the TYPE and replace the numeric value with Dummy as shown

drop type SYS_PLSQL_816EF5E1_DUMMY_1;

drop user mrrame cascade;
user dropped;

No comments:

Post a Comment