SAP Note 1223716 - ORA-932 error after LONG to LOB conversion

Component : Oracle - BW ORACLE

Solution : https://service.sap.com/sap/support/notes/1223716 (SAP Service marketplace login required)

Summary :
Due to an issue with Oracle bug 6679303 affecting data types post conversion from LONG RAW to LOB, SAP reissued patches on March 10, 2009. Users should perform a ROLLBACK using opatch rollback -id 6679303 before reapplying any patch. Errors such as ORA-00932 occur if the LONG RAW to LOB conversion happens while the application runs without a subsequent database restart. Patches are available in the SAP Service Marketplace software center, specifically in directories for Oracle 10.2.0.4 across various Windows platforms. Restarting the database post-conversion is advised to prevent errors.

Key words :
converting long raw fields, previously released single patches, patch collection note 1137346 lists, lob fields online, previously applied patch, windows patch collection 6, important support information, opatch  rollback -id 6679303, sap service marketplace, patch release strategy

Related Notes :

835552Oracle Database 10g: LONG-LOB migration