ORA-65049: Creation of local user or role is not allowed in this container
grant dba to test identified by teast123
*
ERROR at line 1:
ORA-65049: Creation of local user or role is not allowed in this container.
################################################################################################
alter session set "_ORACLE_SCRIPT"=true;
grant dba to test identified by teast123;
Grant succeeded. <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< Created
col USERNAME for a20
set linesize 300 pagesize 300
select USERNAME,COMMON from dba_users ;
USERNAME COM
------------------------------ ---
TEST YES
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0
SQL> create user c##test identified by test123 container=all; otherwise create c## user
User created.
USERNAME COM
-------------------- ---
C##TEST YES