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)
https://www.oracle.com/technetwork/database/multitenant/learn-more/isolation-wp-12c-3614475.pdf
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?
Thanks
Steve
Disclaimer
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.