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

Issue

I tried to drop the PERFSTAT user as follows:

The output was:

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.