I hate it when I hit send to fast... If your column is really a LONG it should have been updated back with 6.3. I have a script that can convert a LONG to a CLOB if you need it.
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, May 26, 2010 10:47 AM To: arslist@ARSLIST.ORG Subject: Re: Upgrade to 7.5 Patch 4 and 5 fails I looked in my 7.1 (on Oracle) and the MSGTEXT column is a CLOB. I'm not sure why yours is a LONG column. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Milke Sent: Wednesday, May 26, 2010 9:52 AM To: arslist@ARSLIST.ORG Subject: Upgrade to 7.5 Patch 4 and 5 fails Hi there, we're on ARS 6.3 with Oracle 9.2 on Linux Red Hat. We're trying to upgrade from 6.3 to 7.5 on Oracle 11 and Linux Red Hat. We tried to upgrade to 7.5 patch 4 and then to 7.5 patch 5; both fail while executing this statement: Failed to run SQL statement [ALTER TABLE ACTLINK_MESSAGE MODIFY ( MSGTEXT CLOB NOT NULL )] Due to [ORA-22296: invalid ALTER TABLE option for conversion of LONG datatype to LOB In order to make the gap between the versions smaller, we've upgraded 6.3 to 7.1. This worked just fine, however the upgrade from 7.1 to 7.5 failed again for the same reason. Any ideas where can we go from here? Mark _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"