Re: Delete datafile(s) - 9.2.0.4 - RHEL3

> Hi Tom
>
> Sounds like you need to move and rename the datafile rather than remove the
> datafile (which you can't really do without dropping the tablespace).
>
> Try taking the tablespace offline (alter tablespace users offline;), move the
> datafile to the correct location using appropriate O/S commands, rename the
> datafile on the database (alter tablespace users rename datafile
> '/u02/oradata/SID/users06.dbf' to '/u02/oradata/SOMEOTHERSID/users06.dbf'; )
> and finally put the tablespace back online (alter tablespace user online;).

ah yes - you are quite correct - I followed your instructions and have managed to remedy my mistake

thanks!

Tom Received on Mon Nov 22 2004 - 08:12:32 CST