Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Datafile for rollback segment

Re: Datafile for rollback segment

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Tue, 8 Oct 2002 19:07:19 +1000
Message-ID: <k7xo9.48490$g9.138655@newsfeeds.bigpond.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US