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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Undo x Rollback Segments in 9i

Re: Undo x Rollback Segments in 9i

From: Joe Testa <teci_at_the-testas.net>
Date: Thu, 20 Sep 2001 18:48:51 -0700
Message-ID: <F001.003944C7.20010920185018@fatcity.com>

have u read the docs on the differences yet?

there is a bit to read about(as i'm going thru it all for a potential presentation on automatic undo management).

i think the verdict has not been decided yet as to whether its good or not as its too new for alot of people.

joe
Eca Eca wrote:
>
> Friends :
>
> I tried to create a rollback segment in 9i and its said to me :
>
> CREATE PUBLIC ROLLBACK SEGMENT "RBS01" TABLESPACE "RBS"
> *
> ERROR at line 1:
> ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
>
> Well, i realized that Oracle created for me some resource like rollback
> segment automaticaly.
>
> My doubt :
>
> If i will put the instance in Manual Undo I can to create the rollback
> segment, but i will lost the resource automatic.
>
> does anyone use it or know how to use Automatic Undo ?
>
> What is the best option :
>
> Rollback or Undo Automatic.
> I know rollback but i don't know Undo Automatic
>
> Regards
>
> Eriovaldo
>
> _________________________________________________________________
> Chegou o novo MSN Explorer. Instale jŠ. … gratuito!
> http://explorer.msn.com.br
>

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: teci_at_the-testas.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Sep 20 2001 - 20:48:51 CDT

Original text of this message

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