Tuesday 10 April 2012

ORA-22600: encountered 8.0.2 (Beta) VARRAY data that cannot be processed

ORA-22600: encountered 8.0.2 (Beta) VARRAY data that cannot be processed

Cause: Production Oracle8 (8.0.3 and beyond) encounters some VARRAY data which was created and stored by Oracle8 8.0.2 (Beta 2). Production Oracle8 cannot understand or process such VARRAY data.

Action: Delete the VARRAY data from the table by dropping the table, deleting the rows, or nulling out the VARRAY columns, and then re-insert the VARRAY data. There is no provided script or tool to help automate this conversion.

No comments:

Post a Comment