Hello, i try to add an column to my table: alter table schema.table add tmpcol varchar(1)
My table has over 6 mio. entries. If i execute the statement i became the following error: File corrupted while reading record: "page[532492] data leaf table:31 ALL_RSC_DATA_COPY_2_0 entries:30 parent:532503 keys:[191111, 191112, 191113, 191114, 191115, 191116, 191117, 191118, 191119, 191120, 191121, 191122, 191123, 191124, 191125, 191126, 191127, 191128, 191129, 191130, 191131, 191132, 191133, 191134, 191135, 191136, 191137, 191138, 191139, 191140] offsets:[2010, 1977, 1938, 1899, 1861, 1823, 1783, 1751, 1712, 1673, 1634, 1595, 1557, 1517, 1479, 1446, 1407, 1368, 1329, 1290, 1250, 1210, 1180, 1140, 1108, 1076, 1037, 997, 965, 925]". Possible solution: use the recovery tool; SQL statement: alter table hts.all_rsc_data add ordchar varchar [90030-162] [SQL State=90030, DB Errorcode=90030] I don't know what is wrong. With best Jochen Schreiber -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
