Question: I need to know the standard
conventions for naming Oracle data files? Does Oracle
have suggested data file naming suggestions?
Answer: Yes, Oracle has the Optimal Flexible
Architecture for data file naming standards. There are
different naming methods for Automatic Storage Management
(ASM) vs. plain Oracle data files:
ASM Data Files
data file naming standards and conventions, see
my notes on Oracle file naming conventions
ASM will create the required files. ASM assigns each file
a fully qualified name ending in a dotted pair of numbers.
More user-friendly alias names can be created for the
Automated Storage Management filenames by using ASM aliases.
For example, here we create an alias for an ASM file
Create an alias doe an ASM datafile
alter diskgroup disk_group_1
Once you have defined an alias for an ASM data file
name, the file name will appear in the
Also see below, the
names of the v$ASM views.
Oracle ASM Parameters.