dropping space with data in it db does not exist
Posted in 2012
IBM Informix Dynamic Server Version 9.40.HC5 - yes i know its not supported. How can i drop a space that has data in it that belongs to a db that has been dropped. The db urb0709 no longer exists I have 4 spaces that I want to drop that have data in them despite dropping the dbs. The db had spatial data in it. see lising below urb0709:'sde'.layer_id_generator 11396 8 urb0709:'sde'.table_id_generator 11404 8 urb0709:'sde'.rastercolumn_id_generator 11412 8 urb0709:'sde'.state_id_generator 11420 8 urb0709:'sde'.version_id_generator 11428 8 urb0709:'sde'.metadata_id_generator 11436 8 urb0709:'sde'.locator_id_generator 11444 8 urb0709:'sde'.connection_id_generator the other space data_sandrifa:'informix'.TBLSpace 1008815 50 FREE 1008865 280 data_sandrifa:'informix'.TBLSpace 1009145 100 FREE 1009245 5984 sandrifa:'irsadmin'.irsadmin_sde_logfile_lid_gen 1015229 8 FREE 1015237 1523 sandrifa:'irsgis'.irsgis_sde_logfile_lid_gen