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 -> Datafile for rollback segment

Datafile for rollback segment

From: Jayaraman Ashok <ashok_jayaraman_at_yahoo.com>
Date: 8 Oct 2002 01:27:55 -0700
Message-ID: <7ca2852.0210080027.22123f38@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 - 03:27:55 CDT












Original text of this message













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