Re: Moving Datafiles

 Well, yes rollbacks are a problem - but even more so is your SYSTEM tablespace, as you can't take it offline. You'll want to look at starting the database 'mounted' but not 'open' and using ALTER DATABASE RENAME FILE. This would solve your problem with rollbacks tablespaces also (although you can do it as outlined below - just create an extra temporary rollback segment elsewhere and take the current ones offline).

Steve Phelan.

Halina Monka wrote in article <33E9E59E.6007_at_ibm.net>...

>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