My Oracle Support Banner

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 FEBRUARY 12, 2022

Applies to:

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

Symptoms

NOTE: In the examples that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.

  

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.