Hi David,
If all else fails, you can create an empty database with the same schema
as the old one, and then siphon data out of the corrupt database into
the new database using the custom tool attached to
https://issues.apache.org/jira/browse/DERBY-6136. Something like this...
call syscs_util.syscs_register_tool( 'customTool', true, 'RawDBReader',
...);
...and then a sequence of statements like this...
insert into myschema.my_table select * from old_myschema.my_table;
Hope this helps,
-Rick
On 9/24/15 4:02 AM, David Sitsky wrote:
Hi all,
I have a database from another user which unfortunately can't boot up
with this error:
ERROR XJ040: Failed to start database 'E:\XXXXXXXX\Database' with
class loader sun.misc.Launcher$AppClassLoader@1540e19d, see the next
exception for details.
ERROR XSDBB: Unknown page format at page Page(7,Container(0, 161)),
page dump follows:
I understand 161 refers to the conglomerate SYSCOLUMNS_INDEX1 and the
file ca1.dat.
Is there any magic I can do to somehow drop this "index" and
regenerate it?
Thanks in advance for any pointers. I checked
https://wiki.apache.org/db-derby/DatabaseCorruption but given this is
a system index and I can't boot the database I don't have any ideas.
Cheers,
David
