Drop Administrative User

Overview

I had installed the PERFSTAT user (for StatsPack). I was unable to drop the user because it was classified as an administrative user.

References

• ORA-28014: Cannot Drop Administrative Users (Doc ID 1566042.1)

Solution

Following the advice in ORA-28014: Cannot Drop Administrative Users (Doc ID 1566042.1), I ran the following command:

I reran the following SQL command:

This worked.