Can't drop down dbspace

I've been restoring a development database from very old backups (long story). Due to errors doing a full DB restore, I restored the critical dbspaces and 1 user dbspace. Logical restore of the next dbspace fails in the same logical log, probably due to a corrupted index. So that dbspace can't be brought online. I'd like to drop this dbspace, along with it's contents, and just recreate/reload it. However, I can't drop the database because the dbspace is offline and I can't drop the dbspace because it contains data. I'm a relative newbie to informix and any help will be appreciated.

On 8/4/06, GARY PRICE <gprice@nationwideprovident.com> wrote: > I've been restoring a development database from very old backups (long > story). > Due to errors doing a full DB restore, I restored the critical dbspaces > and 1 > user dbspace. Logical restore of the next dbspace fails in the same > logical > log, probably due to a corrupted index. So that dbspace can't be brought > online. I'd like to drop this dbspace, along with it's contents, and just > recreate/reload it. However, I can't drop the database because the dbspace > is > offline and I can't drop the dbspace because it contains data. > > I'm a relative newbie to informix and any help will be appreciated. The only course of action I'd recommend is contacting Tech Support. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/