Oracle的PDB数据库创建DIRECTORY时遇到ORA-65254问题及解决方法

在Oracle 19c多租户环境的PDB数据库下面创建一个DIRECTORY时，遇到了“ORA-65254: invalid path specified for the directory”，下面简单演示一下所遇到的这个案例

如上所示，数据库提示，出现这个错误的原因在于创建PDB的语句中指定了PATH_PREFIX参数，创建目录DIRECTORY时只能使用相对路径，而不能使用绝对路径。其实创建PDB时，如果设置了PATH_PREFIX参数，那么这个PDB中的所有对象只能限定在PATH_PREFIX指定的路径下，,只能指定基于PATH_PREFIX的相对路径。官方文档关于这个的解释如下所示：

Restrictions on PDB File Locations

The PATH_PREFIX clause of the CREATE PLUGGABLE DATABASE statement ensures that all directory object paths associated with the PDB are restricted to the specified directory or its subdirectories. This clause also ensures that the following files associated with the PDB are restricted to the specified directory: the Oracle XML repository for the PDB, files created with a CREATE PFILE statement, and the export directory for Oracle wallets. Use this clause when you want to ensure that a PDB's files reside in a specific directory and its subdirectories. You can use this clause to specify one of the following options:

An absolute path that is used as a prefix for all file paths associated with the PDB.

The name of a directory object that exists in the CDB root (CDB$ROOT). The directory object points to the absolute path to be used for PATH_PREFIX.

NONE to indicate that there are no restrictions for the file paths. Omitting the PATH_PREFIX clause is the same as specifying NONE.

After a PDB is created, its PATH_PREFIX setting cannot be modified.

也就是说，如果我要创建一个目录，只能使用相对路径的目录，而且必须在PATH_PREFIX指定的/db19c/oracle_data/PDB6/下面，想指定到其他路径，例如/db19c/exp_dump.此时就会抛出ORA-65254错误。

解决方法

关于这种问题，如果在创建PDB数据库时，不设定参数PATH_PREFIX就不会遇到这个问题。一般没有特殊要求，也不用设定参数PATH_PREFIX。