Re: OFA V. NT default directory structure

You need to reorganize the datafiles to use the I/O most efficiently yourself.
Stop the database and services. Make a copy of the datafile to be moved to the new location. Run svrmgr23 connect internal, issue the command:

        alter database datafile 'oldpath\file' to 'newpath\file';

This will reset where Oracle looks for the datafiles. After running the command issue:

	select * from dba_data_files;
or	select * from v$datafile;

This will give the location the controlfile expects to find the datafile. After verifying the controlfile no longer points to the original path, delete the original datafile at the OS level. This is how to spead out the Oracle datafiles on NT. Currently FOA on NT is a manual process.

Matthew Arrocha
marrocha_at_bellsouth.net

Deborah Luik <dluik_at_sr.csg.com> wrote in article <slrn65frnt.6m0.dluik_at_cobra.sr.csg.com>...
> We are in the process of installing Oracle 7.3 under NT. I noticed that
 the
> default install uses a completely non-OFA directory structure. What do
 most
> people do? Redo the whole thing? Leave it as is? If I go to the trouble
 to
> redo it, do I mess up the installer under NT?
>
> I will probably create a new database anyway because I do not like the
 default
> database name or page size so I could rework the init file and create the
> tablespaces, etc. differently while I'm at it.
>
> Deborah Luik
>
>
Received on Sat Nov 01 1997 - 00:00:00 CST