Avoid GUID path for PDB datafiles in ASM when create PDB using database link from nocdb

mantovamMar 30 2018 — edited Mar 30 2018

Hi folks

When created PDB from nocdb database using the command:

CREATE PLUGGABLE DATABASE pdbtest FROM NON$CDB@clone_non_cdb_test

This command works, but put the datafiles in path :

+DG_DATA/CDB12/68A4A953A4D72D16E0536900A8C0E85A/DATAFILE/system.307.972136815

Is there some option to avoid this created using the GUID - "68A4A953A4D72D16E0536900A8C0E85A" in path of datafile?

We want some like this:

+DG_DATA/PDBTEST/DATAFILE/system.271.970791477

A path without GUID, and using OMF. I tried FILE_NAME_CONVERT, create_file_dest and other command option in CREATE PLUGGABLE DATABASE but no sucess.

Oracle version 12.1.0.2

Added on Mar 30 2018

4 comments

1,724 views