Hi,

What do you call 'base directory' ? If it's PATH_PREFIX then it's related to directory objects only.

I don't think there is a way to force the PDB administrator to create files under a specific folder.

I think it's a valid requirement: you want to given DBA rights to the application owner, in dev for example, but you don't want him to mess up files on your server. That can be a good evolution request, I guess.

Regards,

Franck.

i'm going to consolidate almost 10 non-cdb 11.2.0.2 databases into a single 12cR1 based container using the multitenant architecture's PDB feature.

It is not clear, for me, how to deal with the base directory of the PDBs i'm going to create.

All the documentation i had access to is clear enough for a file-based CDB architecture but I need to consolidate in a 'ASM based' RAC architecture and i'm a bit confused.

I need to avoid the standard naming convention used by the Oracle Based file naming to assign a 'human readable' name to the ASM folder where the datafiles and tempfiles will be stored.

After that I want to be sure that local pdb admins will continue to use that folder name and not another of their choice.

How can I solve this issue?

Since this question is also about ASSM I suggest that you cross-post this question in the Database -General forum.

https://community.oracle.com/community/developer/english/oracle_database/general_questions

ASSM experts in that forum can probably help you but they may not monitor this multitenant forum. Please post links in each thread to the thread in the other forum so that responders to both forums are aware of the other thread.

Since this question is also about ASSM I suggest that you cross-post this question in the Database -General forum.

Do you mean ASM or ASSM ? This question is about multi-tenancy. The requirement can be the same in non-ASM.

ASM.