Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: rollback datafile move
I have done this many times without disrupting database services. I do
it as follows:
1) Create a new rollback tablspace with files the sized and placed where
you want them.
2) Create new rollback segments in that tablespace using a different
naming scheme from the original set.
3) Update the initXXX.ora file to brint the new rollback segments online 4) Take the old rollback segments offline and delete them 5) Drop the old rollback tablespace and delete its datafiles.
-- Andrew Allen Steve wrote:Received on Mon Aug 27 2001 - 23:34:39 CDT
>
> Hi,
>
> I would like to have comment about whether the way to move rollback datafile
> around (not rollback segment) is the same as to move datafile.