Oracle 19c:
ORA-65040: operation not allowed from within a pluggable database, indicates an operation was attempted that can only be performed in the root container.
Issue:
SQL> CREATE OR REPLACE DIRECTORY DATA_PUMP_DIR AS '/zfs/dev/expdp/abc';
CREATE OR REPLACE DIRECTORY DATA_PUMP_DIR AS '/zfs/dev/expdp/abc'
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database
Solution:
SQL> alter session set container=cdb$root;
Session altered.
SQL> SELECT DIRECTORY_NAME,DIRECTORY_PATH FROM DBA_DIRECTORIES where DIRECTORY_NAME = 'DATA_PUMP_DIR';
DIRECTORY_NAME DIRECTORY_PATH
DATA_PUMP_DIR /u01/app/oracle/product/19.0.0.0/dbhome_2/rdbms/log/
SQL> CREATE OR REPLACE DIRECTORY DATA_PUMP_DIR AS '/zfs/dev/expdp/abc';
Directory created.
SQL> SELECT DIRECTORY_NAME,DIRECTORY_PATH FROM DBA_DIRECTORIES where DIRECTORY_NAME = 'DATA_PUMP_DIR';
DIRECTORY_NAME DIRECTORY_PATH
DATA_PUMP_DIR /zfs/backup01/dev/expdp/abc
Refer:
ORA-65040: operation not allowed from within a pluggable database" (Doc ID 2122655.1)
No comments:
Post a Comment