Re: How do I move datafiles?

Hi Terry,

1. Mount the database, do not open it. ( Startup mount DB_NAME)
2. Move (Better copy, just to be on the safe side) the files you wish to move to the new location.
3. Use the alter database rename statement to alter the database controlfiles so it will contain the new locations. ( Alter database rename 'old full dir and filename' to 'new full dir and filename'
4. After you have entered this foor all your files you can open the database

Just for your information you can read this also in the Server Administrators guide Chapter 9 from page 7 on :-)

Have fun trying..... (Just take your precautions so you can always return to the old situation, and the database will function)

Terry wrote:

> Hi all
>
> Sorry, but bit of a newbie question here:
>
> Due to disk space problems it is required to move some of our datafiles to
> new disks. I tried the following using 'Storage Manager' but failed:
>
> 1. Take the tablespace where the datafiles are located offline (Normal
> offline)
> 2. Copy the datafiles to the new disk
> 3. Try to change the path location of the datafile
>
> All I achieved were Oracle errors telling me that it could not locate the
> datafile with the new path location. I am presuming there is some process in
> place to achieve this but unfortunately I haven't had the chance to go on a
> Oracle DBA course to learn this info, and won't have the time in the
> foreseeable future.
>
> Any help would be gratefully appreciated.
>
> Terry Maguire
> IIU
> IFSC House
> Custom House Quay
> Dublin 1
> Ireland

--
With friendly regards,
Met vriendelijke groet,

Geert Roelof van der Ploeg

grploeg_at_orion-it.nl
grploeg_at_xs4all.nl Received on Sat Nov 20 1999 - 08:13:47 CST