Symptom:
We would like to drop ORDS schemas and reinstall ORDS in 18.3 DBSQL> drop user ORDS_PUBLIC_USER cascade;
drop user ORDS_PUBLIC_USER cascade
*
ERROR at line 1:
ORA-28014: cannot drop administrative users
Solution:
SQL> alter session set "_oracle_script"=true;
SQL> drop user ORDS_PUBLIC_USER cascade;
User dropped.
SQL> drop user ORDS_METADATA cascade;
User dropped.
No comments:
Post a Comment