Right rsuri - just noticed that, it can't be open, mounted is ok.

Reading a bit further I found you can do the same thing bt taking the tablespace offline, doing an alter tablespace rename datafile command, & putting the tablespace back online - assuming of course that you have already copied the datafile over with the OS to its new location.

Or is it the same as using alter database??? Whats the difference?, the alter tablespace method seems simpler in that you dont need to shutdown & restart the database.