> > IIRC, there are no guarantees that Oracle will actually save the data > > for 1 hour. It will make a best effort, but a 'storm' of activity > > could subvert that. > > Btw, in 10g, there is.. > You just specify "retention guarantee" when creating an undo tablespace (or > alter it later on). > So, is this 'unbreakable'? Sounds like a challenge. ;) Jared ---------------------------------------------------------------- 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 -----------------------------------------------------------------