From JTESTA@longaberger.com Mon, 24 Sep 2001 06:26:15 -0700 From: "JOE TESTA" Date: Mon, 24 Sep 2001 06:26:15 -0700 Subject: Re: Undo x Rollback Segments in 9i Message-ID: MIME-Version: 1.0 Content-Type: text/plain I'm testing it for potential demo at ioug 2002, since i've got a abstract in for undo management and flashback query.   does that help any?   joe >>> jonathan@gennick.com 09/24/01 09:15AM >>>Thursday, September 20, 2001, 9:40:17 PM, you wrote:EE> does anyone use it or know how to use Automatic Undo ?EE> What is the best option :I don't know which is best. I did recently notice that the defaultdatabase you get when you install Oracle9i uses automaticundo. I also discovered that if you want to use the newflashback query features, that you must be using automaticundo management.I like the simplified approach of "just create a bunch ofundo space and let Oracle worry about it". But it is a newfeature, it may take some time to work the kinks out, andI'm not sure I'd rush to convert all my databases to it.By the way, is anyone doing anything with flashback queryyet?Best regards,Jonathan Gennick   mailto:jonathan@gennick.com * 906.387.1698http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jonathan Gennick  INET: jonathan@gennick.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).