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: Removing OPTIMAL from a rollback segment

Re: Removing OPTIMAL from a rollback segment

From: GoPahDoo <gopahdoo_at_yahoo.com>
Date: 15 Jul 2004 09:14:55 -0700
Message-ID: <62f19488.0407150814.748ec661@posting.google.com> 





"paddy_nyr" <mpprpp_at_yahoo.com> wrote in message news:<2lm06nFe28hvU1_at_uni-berlin.de>...


> Can I do this with an 'alter' command or do I need to take the rollback

> segment offline, drop and recreate?

> 

> I'm using Oracle 8.1.7.4 on Solaris 8.

> 

> 

> Thanks




Try setting optimal to NULL.



i.e.


  alter rollback segment <segment_name>


    storage (optimal null)


  /



HTH.

Received on Thu Jul 15 2004 - 11:14:55 CDT












Original text of this message













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