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

mantovam

Hi folks

When created PDB from nocdb database using the command:

CREATE PLUGGABLE DATABASE pdbtest FROM [email protected]_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

Franck Pachot

Hi,

>> A path without GUID, and using OMF.

By definition, OMF will use GUID. Why do you want something else? The GUID ensures that you have no problem when renaming, cloning, plugging PDBs.

Regards,

Franck.

Unknown

A path without GUID, and using OMF.

Sorry - but that doesn't even make ANY SENSE.

Have you read the Oracle docs about OMF?

https://docs.oracle.com/database/121/ADMIN/omf.htm#ADMIN003

With Oracle Managed Files, you specify file system directories in which the database automatically creates, names, and manages files at the database object level.

See the above where it says 'database automatically creates, names, and manages ...'?

It would NOT be an 'oracle managed file' if the user is involved in naming the file.

The VERY DEFINITION of OMF means Oracle will name the files.

Read that entire doc chapter. And especially read this section

17.3.2 How Oracle Managed Files Are Named

The file names of Oracle Managed Files comply with the Optimal Flexible Architecture (OFA) standard for file naming.

mantovam

Hi rp0428

I read and know about OMF.

I already use this in database, but the GUId path is only used in PDB.

But in some situations like when you transform a database nocdb to pdb ,that are in same server ASM using nocopy , you stay with the datafile in OMF but without GUID.

I want know if have a parameter to indicate a path and try avoid create guid number for this command:

CREATE PLUGGABLE DATABASE pdbtest FROM [email protected]_non_cdb_test

Tks

Unknown

And I already answered that and provided the doc quote to support it.

If you want to name your own files then don't use OMF.