ORA-28014: Cannot Drop Administrative Users

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 21 Dec, 2023
  • 0 Comments
  • 1 Min Read

ORA-28014: Cannot Drop Administrative Users

Solution :

set _oracle_script to TRUE and execute drop command as below.
SQL> alter session set “_oracle_script“=true;
Session altered
SQL> drop user TEST cascade;
User dropped.