Oops. My Bad. The *setup* is on-line, through 'alter system... scope=pfile' commands. Then there is a bounce. Hey...I told you I didn't do it their way! Besides...SAP doesn't support the use of SPFILEs yet, but their docs show commands that record to SPFILES. Odd. Cheers, Mike -----Original Message----- From: Freeman Robert - IL [mailto:FREEMANR@xxxxxxxx] Sent: Wednesday, February 25, 2004 8:44 AM To: Vergara, Michael (TEM); 'oracle-l@xxxxxxxxxxxxx ' Subject: RE: to undo or not to undo >> SAP has a very nice note titled "Oracle 9i: Automatic UNDO >> Management", and it describes a method of switching over while >> on-line. Yikes! Since the undo_management parameter is static, I'm currious how they plan on doing the switchover online.... Robert ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------