Sample Header Ad - 728x90

Oracle AWS package errors when removing user

0 votes
1 answer
152 views
We are getting the folowing error when attempting to remove a user from our 11g Oracle. a dump from an Amazon DB was (failed) imported, and now we see this. ERROR at line 1: ORA-00604: error occurred at recursive SQL level 2 ORA-04045: errors during recompilation/revalidation of {USER}.RDSADMIN ORA-04067: not executed, package body "{USER}.RDSADMIN" does not exist ORA-06508: PL/SQL: could not find program unit being called: "{USER}.RDSADMIN" ORA-06512: at line 2 ORA-06508: PL/SQL: could not find program unit being called: "{USER}.RDSADMIN" ORA-06512: at line 2 How do we remove this {USER} and it's RDSADMIN packages? Thanks in advance C
Asked by KS1 (201 rep)
Mar 12, 2019, 02:47 PM
Last activity: Jul 17, 2025, 09:02 PM