Re: MOVE DATAFILE SCO UNIX possible ?

Sean Kubovcik wrote:
>
> Try:
> Take tablespace offline
> At OS, copy old file to new file system
> Run: alter database 'old /dir/file' to 'new /dir/file';
> Put tablespace online
> Test
> Delete old file

This won't work, because...

> >BTW it is a part of the system tablespace.

... and you can't take the system tablespace offline. What you need to do is shut down the database, do a 'startup mount', move the datafile to the correct location and then use 'alter database rename file xxx to yyy'. You can then open the database.

-- 
Alan Burlison
alanburlison_at_unn.unisys.com

My opinions may be incorrect, but they are my own.