ORA-28014: cannot drop administrative user or role

kIsH@Xhydra<>drop user test cascade;
drop user test cascade
*
ERROR at line 1:
ORA-28014: cannot drop administrative user or role

kIsH@Xhydra<>!oerr ora 28014
28014, 00000, "cannot drop administrative user or role"
// *Cause:    An attempt was made to drop an administrative user or role.
//            An administrative user or role can be dropped only by SYS during
//            migration mode.
// *Action:   Drop the administrative user or role during migration mode.
//

Solution:

kIsH@Xhydra<>alter session set "_ORACLE_SCRIPT"=true;

Session altered.

kIsH@Xhydra<>drop user test cascade;

User dropped.

Leave a Reply