BDS V2.0-Creating a directory object in the PDB Raises: "ORA-65040: operation not allowed from within a pluggable database"

(Doc ID 2122655.1)

Last updated on NOVEMBER 01, 2017

Applies to:

Oracle Big Data SQL - Version 2.0 and later
Linux x86-64

Symptoms

On BDS V2.0 trying to create a directory object in the PDB Raises: ORA-65040: operation not allowed from within a pluggable database

For example:

CREATE or REPLACE DIRECTORY ORACLE_BIGDATA_CONFIG as '/u01/app/oracle/product/12.1.0.2/orahome_1/bigdatasql/bigdata_config'
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms