Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I move datafiles?
These are the steps to do so:
1)Take the Tablespace using these datafiles offline:
ALTER TABLESPACE tb1 OFFLINE;
2)Copy the datafile to the new location using os commands
3)Use the alter tablespace command to assign the new datafile:
ALTER TABLESPACE tb1 RENAME
DATAFILE '/disk1/tb1.dbf' TO '/disk2/tb1.dbf'
4) Bring the tablespace online
Terry <tmaguire_at_iiu.nospam.ie> wrote in message
news: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 Wed Nov 17 1999 - 10:10:31 CST