Drop Administrative User

Contents

  1. 1 Overview
  2. 2 Status
  3. 3 References
  4. 4 Issue
  5. 5 Solution

Overview

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

Status

RESOLVED

References

Issue

I tried to drop the PERFSTAT user as follows:

drop user perfstat;

The output was:

drop user perfstat
*
ERROR at line 1:
ORA-28014: cannot drop administrative users

Solution

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

alter session set "_oracle_script"=true;

I reran the following SQL command:

drop user perfstat cascade;

This worked.

User dropped.