How To List/Find PATH_PREFIX parameter value in pluggable database

PATH_PREFIX is a parameter used while pluggable database is being created to ensure user-level directories are created in a certain pre-defined directory in the operating system. The parameter is optional and must be specified during database creation.

How to know the parameter value of PATH_PREFIX in a pluggable database….you can know that using cdb_properties view in a pluggable database level:

sqlplus / as sysdba

The parameter was introduced in Oracle 12cR2 as a security in enhancement in CDB architecture.

sources:

https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/overview-of-pdb-creation.html#GUID-7AC4C851-4E5E-4622-9B29-31D5A1C98426

Leave a comment