Re: How do I move datafiles?

After you've copied the file :
Mount the database and then use: alter database rename file 'a' to 'b'

--
Terry Dykstra
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

Terry wrote in message <80ujc7$e8e$1_at_ezekiel.eunet.ie>...
>
>
>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
>
>
>
>
Received on Wed Nov 17 1999 - 10:10:41 CST