- Take the tablespace offline.
- Copy or move the datafile to new location
- ALTER TABLESPACE RENAME datafile
- Bring tablespace online
- Delete the old datafile.
Terry wrote in message <80uiti$dul$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 Thu Nov 18 1999 - 14:48:17 CST
