This content has been marked as final. Show 8 replies
This is related to ASM.
In ASM, these are OMF(oracle managed files)
may i know in which format i will assign the names.
in which format i will assign the names.Do you mean, for example, when creating a tablespace ? If so, it's sufficient that you specify the diskgroup, e.g.
SQL> create tablespace <tablespace name> datafile '+DATA' <all other parameters>
no, how it generates the file names.
if file name is "SYSAUX.257.795646467" what is this 257 and 795646467. what represent it.
if file name is "SYSAUX.257.795646467" what is this 257 and 795646467. what represent it.http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmfiles.htm#OSTMG94200
A fully-qualified file name comprises the following five components, and always ends with a special number pair:
<group>. The name of the ASM disk group.
<dbname>. The database that owns this ASM file.
<file type>. The Oracle file type (e.g. DATAFILE, ARCHIVELOG, CONTROLFILE).
<tag>. Type-specific information about the file. In this case, it is the corresponding tablespace name for the datafile.
<file>.<incarnation>. A special number pair that ASM generates to insure uniqueness.