Re: Moving Datafiles

BRAJB wrote:
>
> I would recommend the following:
>
> 1. alter tablespace offline
> 2. copy the datafile to the new location
> 3. alter datafile, rename to the new location
> 4. alter tablespace online.

Yes, but it will only work for tablespace which does not contain active rollback segment !
If it does, first offline the rollbacks in this tablespace ( you might have to create temporary rollback in another tablespace , you need one active rollback at least ) , do rename datafile and when done, activate rollbacks again.
One would use this method to rename datafile for rollback tablespace - you do keep all rollbacks in one tablespace, right? Halina Received on Thu Aug 07 1997 - 00:00:00 CDT