Erro ORA-28014: cannot drop administrative users
|
1 2 3 4 5 |
SYS@ORCL > drop user perfstat cascade; drop user perfstat cascade * ERROR at line 1: ORA-28014: cannot drop administrative users |
Alterando o parâmetro _oracle_script
|
1 2 3 |
SYS@ORCL > alter session set "_oracle_script"=TRUE; Session altered. |
Dropando
|
1 2 |
SQL> drop user perfstat cascade; User dropped |
Resolvido! Recomendo que volte depois o parâmetro para FALSE
|
1 |
SYS@ORCL > alter session set "_oracle_script"=FALSE; Session altered. |