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:[email protected]] On Behalf Of Mark Milke Sent: Wednesday, May 26, 2010 9:52 AM To: [email protected] 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"
