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: Jayaraman Ashok <ashok_jayaraman_at_yahoo.com>
Date: 8 Oct 2002 19:55:15 -0700
Message-ID: <7ca2852.0210081855.1df7c51c@posting.google.com>


Hi HJR

I did it purely for academic interest. Since when a tablespace has 2 datafiles and if one of them is online, you are allowed to create a table on that tablespace, then why not the same for a rollback, as both are creating only segments. More clarification / explanation is requested from all.

Cheers,
Ashok

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<k7xo9.48490$g9.138655_at_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 - 21:55:15 CDT

Original text of this message

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