OMF

Can you create more than one pluggable database (PDB) within the same directory?
And how does the file naming work? Considering the fact each PDB’s SYSTEM tablespace will be named system01.dbf by default the question is not trivial.

This question got asked by a customer during one of the workshops in Switzerland last week. And the solution is straight forward. Thanks to Roy for trying it out yesterday at 170 km/h on our way back from Stuttgart 🙂

Thanks 🙂

-Mike

Additional information:

Within ASM with OMF the file structure looks like this:

select con_id, substr(file_name,1,90),tablespace_name from cdb_data_files order by 

… Continue reading...