Hi there, We had a nightmare upgrade from 8.1.6 to 8.1.7 because of the way our application code was written. There were commits within cursor for loops - which caused the loop to end - thus not dealing with all the data in the cursor. Might be something to look out for, good luck! N. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Andrey Bronfin Sent: 01 February 2004 15:22 To: oracle-l@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx Subject: RE: upgrade from 8.1.6 to 8.1.7 THANKS A LOT TO ALL WHO REPLIED !!! -----Original Message----- From: MacGregor, Ian A. [mailto:ian@xxxxxxxxxxxxxxxxx] Sent: ? 01 ?????? 2004 4:30 To: 'oracle-l@xxxxxxxxxxxxx'; oracledba@xxxxxxxxxxx Subject: RE: upgrade from 8.1.6 to 8.1.7 The most common problem is the failure to disable the system level triggers and job queues during the upgrade Are you using any of the OWA packages? 8.1.7 installs these in the sys schema and establishes public synonyms for them. It is possible some of your programs will not work with these new packages. It is quite probable WebDB will not work with sys.OWA packages. If the database supports a third party application, be sure to visit that site for cetification and known problems. Ian MacGregor Stanford Linear Accelerator Center ian@xxxxxxxxxxxxxxxxx -----Original Message----- From: Andrey Bronfin [mailto:andreyb@xxxxxxxxxxxxxxxxx] Sent: Thursday, January 29, 2004 5:34 AM To: oracle-l@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx Subject: upgrade from 8.1.6 to 8.1.7 Hi friends ! I'm about to upgrade a DB rom Oracle 8.1.6 EE 32-bit to Oracle 8.1.7 EE 32-bit on HP-UX 11.11 Are there any known issues, pitfalls etc. thta I'd better be aware of before i begin ? Thanks a lot in advance. P.S> No, i can not upgrade to Oracle 9.* neither can i go 64-bit ;-) ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------