ORA-28014: cannot drop administrative users

Hello Friends,

This post we will discuss over error ORA-28014: cannot drop administrative users

so lets get started

SQL> alter session set container=TPDB;

Session altered.

Error : ORA-28014: cannot drop administrative users

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

Set "_oracle_script" parameter session level as shown below to TRUE

The _oracle script parameter, introduced in Oracle Database 19c, allows you to run a SQL script as a "container database" (CDB) or a "pluggable database" (PDB). When you create or clone a PDB, this parameter specifies the location of the SQL script that will be executed.

When you create or clone a PDB, the _oracle script parameter instructs the database on which SQL script to run during the process. SQL commands that set up PDB-specific objects such as users, roles, tablespaces, and other database objects can be included in the SQL script. You can automate the process of creating or cloning PDBs and ensure consistency across your database environment by using the _oracle script parameter.

A file system path or a URL can be specified as the _oracle script parameter. When the database starts up, it looks for the SQL script specified by the _oracle script parameter and executes the commands in the script to create or clone the PDB.

It is important to note that the _oracle script parameter is only used when creating or cloning a PDB and is ignored during normal database operation.

SQL> alter session set "_oracle_script"=TRUE; 

Session altered. 

Drop the user

SQL> drop user APEX_040200 cascade; 

User dropped. 

SQL> drop user DBVUSR cascade; 

User dropped. 

make the "_oracle_script" parameter session level to FALSE

SQL> alter session set "_oracle_script"=FALSE; Session altered.
Regards Sultan Khan
Next Post »