Re: Relocating Tablespace

Thanks. I ended up using this in the end and it worked fine. I will remember for next time. Dont have to do this so often so dont really get into practise :)

Thanks again for all your help

regards

Tony
Scotland

"Jeremy Russell" <jeremy.russell_at_usa.net> wrote in message news:3c5fe131.61717975_at_news.earthlink.net...
> Tony, since this is a tablespace containing rollback segments, it
> can't be taken offline whilst the rollback segments are active and
> open.
>
> The easiest solution ( easiest = least typing ;) is to shutdown the
> instance, issue a "STARTUP MOUNT pfile=whatever" to mount but not open
> the database.
>
> Then, copy the datafile to it's new location and then issue
>
> ALTER DATABASE RENAME FILE
> 'old full path' TO 'new full path'.
>
> then
>
> ALTER DATABASE OPEN
>
> After that, you can safely delete the old datafile.
>
> On Tue, 5 Feb 2002 10:21:14 -0000, "Tony" <ar_at_hotmail.com> wrote:
>
> >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 Tue Feb 05 2002 - 12:07:47 CST