The naming convention for the different file types under the oradata directory are
detailed in Table 3-1.
FIGURE 3-5 OFA-compliant Unix directory structure
70 Oracle Database 11g DBA Handbook
Although Oracle tablespace names can be as long as 30 characters, it is advisable to keep
the tablespace names eight characters or less in a Unix environment. Because portable Unix
filenames are restricted to 14 characters, and the suffix of an OFA datafile name is
.dbf, where
n is two digits, a total of six characters are needed for the suffix in the file system. This leaves
eight characters for the tablespace name itself.
Only control files, redo log files, and datafiles associated with the database
should be stored in the directory //oradata/. For the database ord
managed without ASM, the datafile names are as follows:
SQL> select file#, name from v$datafile;
FILE# NAME
---------- -----------------------------------
1 /u05/oradata/ord/system01.dbf
2 /u05/oradata/ord/undotbs01.dbf
3 /u05/oradata/ord/sysaux01.dbf
4 /u05/oradata/ord/users01.dbf
5 /u09/oradata/ord/example01.dbf
6 /u09/oradata/ord/oe_trans01.dbf
7 /u05/oradata/ord/users02.dbf
8 /u06/oradata/ord/logmnr_rep01.dbf
9 /u09/oradata/ord/big_users.dbf
10 /u08/oradata/ord/idx01.dbf
11 /u08/oradata/ord/idx02.dbf
12 /u08/oradata/ord/idx03.dbf
13 /u08/oradata/ord/idx04.dbf
14 /u08/oradata/ord/idx05.dbf
15 /u08/oradata/ord/idx06.
Pages:
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169