Trending
Blog for DBA, RAC, EBS DBA
You are at:»»ORA-28014: cannot drop administrative users

ORA-28014: cannot drop administrative users

0
By on DBA 
SQL> alter session set container=pdb1;

Session altered.

SQL> drop user hari;
drop user hari
*
ERROR at line 1:
ORA-28014: cannot drop administrative users

Solution
SQL> alter session set "_oracle_script"=TRUE;

Session altered.

SQL> drop user hari;

User dropped.

https://oracledbwr.com/ora-28014-cannot-drop-administrative-users/
Share.

About Author

Related Posts

Leave A Reply