While deleting old version of ApEx you are getting the:
ERROR at line 1:
ORA-28014: cannot drop administrative users
Solution:
SQL>; alter session set “_oracle_script”=true;
Session altered.
SQL> drop user apex_040200 cascade;
User dropped.
While deleting old version of ApEx you are getting the:
ERROR at line 1:
ORA-28014: cannot drop administrative users
Solution:
SQL>; alter session set “_oracle_script”=true;
Session altered.
SQL> drop user apex_040200 cascade;
User dropped.
salam mazin bhai
there are any command through which we can check the user details i mean
to show us username and its concern pdb in oracle 12 c
please help me.
fore example we have hundred of pdbs and each pdb contain 100 of user
how to check that how to check that user belong to that pdb.
thanks in advacne..
Regard
Wajid khan
Hi Wajid Khan, sorry for late reaction, this blog is specific for dropping an admin user in Oracle.
Mazin bhai Salam
i have created a user name oracleadm and granted create session priv to it but still not connecting
show the ora-01017: invalid uername/password logon denied
my username and password not wrong