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.