Subject | Re: [firebird-support] How can I check to see if a table is corrupted? |
---|---|
Author | Thomas Steinmaurer |
Post date | 2013-03-08T16:35:03Z |
> I have a table that appears to be corrupted because any SQL I run against it just runs. The table has a little over 976,000 rows. I can't drop or delete from the table. Is there a way I can either force drop the table or repair it?You can't drop a table when it's being in use by concurrent requests,
which haven't been committed.
> I do have the data to rebuild the table.If you are on >= 2.1, then go into the monitor tables and investigate
>
> Thank you very much for your help.
what statement is accessing your table. Perhaps a long-runner.
Thomas