We are trying to expand column in one of our tables from Numeric-4 to Integer.
Here is statement: ALTER TABLE "DBA"."ps_detail" ALTER "brand" INTEGER;
We are getting an error:
Run time SQL Error -- *** ERROR *** Assertion Failed: 109900 (220.127.116.1142) [Backup] Error decoding ROWID SQLCODE=-300, ODBC 3 State-"HY000"
Can any one give me a sense of what this error means and how I can avoid it?
It sounds like there may have been some index corruption and that the corruption was preventing the server from deciphering a valid ROWID, the location of the row, from the index. Dropping the primary key likely resolved this.
answered 06 Feb '15, 09:34