db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "George S." <geor...@mhsoftware.com>
Subject Re: How to drop a bad table?
Date Mon, 18 Nov 2013 17:46:09 GMT
One solution that would work with pretty much any system is to copy the 
non-bad tables to a new database, drop the bad database, and rename the 
new database.


On 11/17/13 8:53 PM, chongsoft wrote:
> I'm  using derby for 4 years, all the time I don't known how to drop a bad
> table( file damaged)?
>
> For example, if a file in "seg0" named "c20.dat" is damaged or deleted, so
> the associated table "tablexxx" can not be used,and even cannot de droped
> with "drop table tablexxx"(thows exceptions), can someone help me to remove
> the damaged table "tablexxx"?
>
>
>
> --
> View this message in context: http://apache-database.10148.n7.nabble.com/How-to-drop-a-bad-table-tp135693.html
> Sent from the Apache Derby Users mailing list archive at Nabble.com.
>

-- 
George Sexton
MH Software, Inc.
303 438-9585
http://www.mhsoftware.com/


Mime
View raw message