Originally posted by davey23uk
yes you can

take the tablespace offline (or startup mount)

alter database datafile 'xxxx' rename to xxx' then copy the file to wherever you want it to be then online your tablespace or open it, make sure you can use the same tablespace and remove old file.

The sql syntax may be wrong - it is from memory

I think the order is very important.


1. take the tablespace offline.

2. copy the file to new location

3. alter database rename file oldname to newname

4. take the tablespace online.

because, when you rename the file it looks for file in the
new location.

-Raja