How do I move datafiles?

From: Terry <tmaguire_at_iiu.nospam.ie>
Date: Wed, 17 Nov 1999 15:57:33 -0000
Message-ID: <80ujc7$e8e$1@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:

Take the tablespace where the datafiles are located offline (Normal offline)
Copy the datafiles to the new disk
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 - 09:57:33 CST