> 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. > > Thank you very much for your help. If you are on >= 2.1, then go into the monitor tables and investigate what statement is accessing your table. Perhaps a long-runner. Thomas
