Originally posted by hrishy
pando can you please explain what do you mean by the above statement..well all oracle9i boasts about this OMF feature..why do you think its bad ?
can you elaborate
regards
Hrishy
Hi Hrishy,
The point is no one will want to put all its datafiles on one volume defined by DB_CREATE_FILE_DEST for a production database.
Yes, you can dynamically change this parameter but it invloves same amount of work compared to manually mentioning the path.
Also the filenames assigned by OMF is a bit complex.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"