ORA-28014: cannot drop administrative users

Hello,

After Oracle 12c, when you try to drop the user present in container database, you will get ORA-28014 error as below.

SQL> alter session set container=cdb;

Session altered.

SQL> drop user talip;

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

Solution: For dropping the user present in Container ROOT, we need to set value of the hidden parameter “_ORACLE_SCRIPT” to FALSE.

SQL> alter session set “_oracle_script”=TRUE;
Session altered.
SQL> drop user talip;

User dropped.

Note: Please also visit oracle document (Doc ID 1566042.1)

Advertisement