Hi, I have a database table POS_RESOURCES.RESOURCES that has been corrupted. There is a Mirror file to this so easy to recreate it but I am unable to delete it due to the corruption.
Whatever I try and do to the table I get them same result of: SQLState: 08006 ErrorCode: 40000 Error: DERBY SQL error: SQLCODE: -1, SQLSTATE: XSDG2, SQLERRMC: Invalid checksum on Page Page(0,Container(0, 474144)), expected=229,350,622, on-disk version=1,888,684,690, page dump follows: Hex dump: 00000000: 0076 0000 0001 0000 0000 0000 93b4 0000 .v..........ﾓﾴ.. 00000010: 0000 0006 0000 0000 0000 0000 0000 0000 ................ 00000020: 0000 0000 0001 0000 0000 0000 0000 0000 ................ And the hex dump continues for ages. What can I do to just delete this table and then rebuild it from the Mirror file? Thanks. -- View this message in context: http://apache-database.10148.n7.nabble.com/deleting-a-corrupted-database-with-invalid-checksum-on-page-tp137773.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
