Re: Moving a tablespace to another drive !

In article <310fa4$7ju_at_netserver.univ-lille1.fr> noel_at_omega.univ-lille1.fr (Yves Noel) writes:

> Hi all DBA's
>
> The scenario : one tablespace (content : rollback segments and temporary files)
> which has been increased three times with a new file, so it contains now 4 files
> (with the command : alter tablespace xxx add datafile ...).
> Today I've new drives and I want in particular to move this tablespace and it's
> four files on a new drive.
> Can somebody tell me the differents stages to do this ? Thanks in advance.
>
> Email: Yves.Noel_at_univ-lille1.fr

I have successfully used a procedure like this: (details may be wrong)

1. Make a copy of all your .dbf files to the new drive. ===> DO NOT delete the original files yet. <===
2. enter the following using sqldba (or sqlplus): alter tablespace yourspace offline; alter database rename file 'file1','file2',file3','file4' to 'newfile1',... ;
   • By now the new files will be used by the dbms. alter tablespace yourspace online;
3. Rename the old files.
4. Verify that data are accessible in your tablespace.
5. Remove the old files when your are certain there is no magic involved.

--
Oddmund.Johannessen_at_delab.sintef.no