Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Datafile for rollback segment
Can I just ask why you care where the rollback segment is physically
created?
HJR
"Jayaraman Ashok" <ashok_jayaraman_at_yahoo.com> wrote in message
news:7ca2852.0210080027.22123f38_at_posting.google.com...
> Hi
> I have two datafiles for rollback segment tablespace and have enough
> free space on both the datafiles. Now to create a rollback segment in
> one specific datafile i offline the other datafile and try to create
> the rollback segment, which naturally must create it on the online
> datafile. But it is failing with ORA-3113 and i have to do media
> recovery to bring it back online. What is wrong here ? The setup is
> Oracle8.1.7.0.0 on Solaris7.
>
> Cheers,
> Ashok
Received on Tue Oct 08 2002 - 04:07:19 CDT