Oracle-Managed Files - your views
Date: Tue, 15 Dec 2009 16:20:15 +0000
I have to move a 10g (10.2.0.3) application off a Solaris 10 machine (using ASM) to a Windows 2003 server (don't ask).
The required application is only one smallish schema, so I'm going to pre-create a database (10.2.0.4) and use export/import.
I'm thinking of using OMF. Does anyone here have any views on OMF. My research has come up with the following:
Primary advantage seems to be management (no need to specify file names/locations...)
The list of disadvantages I have found are all dismissable for this particular application.
File System only - I'm OK with that
Naming Standards - No issue for this database
Tuning - Again no issue for this database.
-- S. Anthony SequeiraReceived on Tue Dec 15 2009 - 10:20:15 CST
It is bad luck to be superstitious. -- Andrew W. Mathis