Friday, May 26, 2023

ORA-65040: operation not allowed from within a pluggable database

 Starting 12c, after introduction of pluggable databases, there are certain operations that can be performed only at the root container level. If you try to execute that operation/SQL within the PDB, you will receive ORA-65040. In this case you must ensure that the command you are executing is being executed at the root container level. Following is only one example of such operations that can only be performed from the root container.

SQL> create pluggable database testdb from proddb keystore identified by wallet_passsword;
create pluggable database testdb from MWR1P011 keystore identified by wallet_password
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database

No comments:

Post a Comment

Popular Posts - All Times