Database Administration (MOSC)

MOSC Banner

Using GUID versus not using GUID?

edited Jan 11, 2023 9:50PM in Database Administration (MOSC) 10 commentsAnswered

Any best practice in using GUID versus not using GUID on regular file system with less than 3 PDBs?

With many PDBs in a container database, we can see the value of the GUIDs, but oracle forces us to use it no matter how many PDBs you have in a container database by default.

The 32 character long GUID embedded into the datafile path is complex and confusing. We just don't see the value to have it for every pdb.

We could avoid using it with the option FILE_NAME_CONVERT to not using GUID where OMF is still enabled to avoid the confusion where we can clearly see which directory is for which PDB based on its actual name rather than GUID.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center