How to alter PATH_PREFIX in a PDB after creation

From: Steve Wales (AddOns) <"Steve>
Date: Thu, 2 Jul 2020 07:35:54 +0000
Message-ID: <>

Using Oracle 18.9 Enterprise on Linux 7

I have create a PDB (several of them in fact, in an existing container) and am trying to define an Oracle directory so that I can perform an import datapump operation.

When I try (after launching SQLPLUS and changing current container to the PDB I want to work with)

SQL> create directory backups as '/mnt/mydirectory'; create directory backups as '/mnt'
ERROR at line 1:
ORA-65254: invalid path specified for the directory

I've done some research amd it appears that when the PDB was created with the PATH_PREFIX option. I don't remember doing that though.

Two questions:

  1. Where can I see the value of this setting (I have looked everywhere I can think of and can't find it)
  2. How do I change it (or better, remove it).

I have been rummaging through google searches, the Oracle documentation and My Oracle Support with no joy so far.

Recreating this PDB is really not an option at the moment (we're in the middle of an upgrade project and there's considerable stuff built pointing to it) and I'm sure when I originally built it I did an import.

The datapump dump file is 120GB, so it can't just go anywhere. Before I dropped the directory in an attempt to recreate it, it was stating +DATA//mnt/mydirectory

Doing: create directory test as 'test' - creates a directory with a path of +DATA/test so I'm pretty sure that my PATH_PREFIX is +DATA which isn't helping me here at all.

I have seen several parts of the docs that tell you have to create a PDB with this setting, but nothing on how to change it or check what it was set as.

Right before hitting send on this I did finally find a whitepaper that seems to indicate I'm in a lot of trouble (see page 5)

This is for Oracle 12, not Oracle 18 but I'm not holding out much hope.

I'm not very fluent in the intricacies of ASM but if Oracle let's you export to as ASM directory, I figure there has to be a way to drag my 120GB datapump export file into +DATA inside ASM somehow. Maybe that's my solution? How would I manage to go about that ?

Anyone able to offer me some help on this one please or am I just royally hosed at this point?



The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been automatically archived.

Received on Thu Jul 02 2020 - 09:35:54 CEST

Original text of this message