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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).