Re: Moving Datafiles

Daniel P. Ritsma wrote:

> We are running Oracle 7.3 on a NT4.0 Server station. Our datafiles are
>
> stored on 2 of our 25 drives, and for tuning reasons I want to move
> these
> datafiles over more drives. How do I move datafiles over more drives?
>
> I know there is a way to do it something like first copy the files,
> then
> bring the server up and do an Alter Datafile command. But I would
> like to
> be sure before I start.
>
> Thanks for your help.
>
> Ritsma.

Here is a very basic overview. You might want to consult the Oracle7 Server Admin guide before you attack this problem:

1. Shutdown the database by connecting internal and issuing either a SHUTDOWN IMMEDIATE or a SHUTDOWN NORMAL.
2. Startup and mount (but do not open) the database by issuing a STARTUP MOUNT.
3. Move the files in question with an O/S tool or utility (such as NT Explorer) to their desired location.
4. From Oracle Server*Manager, issue the following command for each database file which is moved:

    ALTER DATABASE
    RENAME FILE 'full_path_of_old_file_name' TO 'full_path_of_new_file_name';

5. Issue the ALTER DATABASE OPEN command.

That should do the trick.

--
====================================================================
Byron Pearce                         mailto:bpearce_at_csac.com
Systems Consultant                   http://www.csac.com
Computer Systems Authority (CSA)     Dallas, Texas

"It's hard to be a ninja when you wear a beeper."