At 01:19 PM 3/2/2004, you wrote:
Your original error indicated that your undo_retention value was too small to process the original query. This is different than the size of the undo_tablespace. They are related. The higher the undo_retention, the more undo space one needs. Obviously it was better to fix the query, than to increase the undo_retention value.
Ian MacGregor Stanford Linear Accelerator Center ian@xxxxxxxxxxxxxxxxx
---------------------------------------------------------------- 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 -----------------------------------------------------------------