ORA-28014: cannot drop administrative users
Error
In Oracle 12c, when i tried to drop the user present in container database which having data of my application for IMPDP the same user then i got the following error with DROP command:
SQL> drop user hr01;
drop user hr01
*
ERROR at line 1:
ORA-28014: cannot drop administrative users
Solution
For dropping the user present in Container ROOT, we need to use the hidden parameter “_ORACLE_SCRIPT”.
SQL> alter session set "_oracle_script"=true;
Session altered.
SQL> drop user hr01;
User dropped.