What You can do is.
- Take all the RBS offline.[Hope you have others if not create one RBS for the Time being and then drop them]
- Take the tablespace offline. [ Users will not be able to use this Tablespace]
- Copy the datafile to the new location.
- Issue the command Alter Database rename File <source> to <dest>
- Alter Tablespace online.
- Alter system Switch Log file.
- Take a Backup of the Tablespace and the Controlfile.
- Delete tha file after the check is complete.
--
HTH
Additions and Corrections Welcome.
Regards,
Ganesh R
"Tony" <ar_at_hotmail.com> wrote in message news:1012904327.13225.0.nnrp-02.d4f0f429_at_news.demon.co.uk...
> Hi
>
> Am new to DBA type stuff lol. I have a reporting server here and have noted
> that one of the system drives has filled up. Examining the storage schema I
> have noted that a TABLESPACE called RBS has a DATAFILE and a number of
> ROLLBACK segments associated with it.
>
> What I would like to do is to relocate the DATAFILE. How do I do this the
> most affective way with the knowledge that the rollback segments are
> aassociated with this tablespace? Can I do this whilst users are on line or
> not ?
>
> Do I create a new Datafile on another drive then take the old one off line
> and delete the old one.? Do I need to take the rollback segments off line
> whilst i make this change ?
>
> Any help would be useful
>
> Thanks
>
> Tony Rees
> DMC Stratex Networks
> 5th Jan 2002
> .
>
>
Received on Wed Feb 06 2002 - 03:06:38 CST
