Hi,
I am hoping to start using RDS Oracle with Multi-Tenant support(CBD), but I am struggling to create another PDB (a clone of the first PDB ORCL) using the master user "admin".
CREATE PLUGGABLE DATABASE ORCL1 FROM ORCL
Error report -
ORA-65040: operation not allowed from within a pluggable database
65040. 00000 - "operation not allowed from within a pluggable database"
*Cause: An operation was attempted that can only be performed in the root
or application root container.
If I try to switch to root
alter session set container=CDB$ROOT
Error report -
ORA-01031: insufficient privileges
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to perform a database operation without
the necessary privileges.
*Action: Ask your database administrator or designated security
administrator to grant you the necessary privileges
I have also tried another user and tried to assign the privileges for both of the above but I get a permission denied. Has anyone done similar?
Thanks