1、已drop要使用blob空间的库,实例只剩下一个生产库
2、删除表tabid 对应(syscolumns coltype =11,12 (text,byte))
能想到的都已经做了,还是报不能为
数据库信息如下:
[code class="lang-Command" lang="Command"]onspaces -d blobdbs -y
Cannot drop the Space.
ISAM error: DBspace is not empty
oncheck -ce blobdbs
Validating BLOBSpace 'blobdbs' ...
7 D:IFMXDATAds_blobdbs_dat.000 524032 34 523998
oncheck -pe blobdbs
BLOBspace Usage Report: blobdbs Owner: informix Created: 11/18/2010
Chunk Pathname Size Used Free
7 D:IFMXDATAds_blobdbs_dat.000 524032 34 523998
Disk usage for Chunk 7 Total Pages
-------------------------------------------------------------------------------
OVERHEAD 34
FREE
523998
onstat -d update
Informix Dynamic Server Version 9.30.TC1 -- On-Line -- Up 38 days 04:25:21 -- 297984 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
1bc027d0 1 0x1 1 1 N informix rootdbs
1bf845b8 2 0x1 2 11 N informix datadbs
1bf84700 3 0x8001 3 1 N S informix sbspace
1bf84848 4 0x1 4 1 N informix logdbs
1bf84990 5 0x1 5 1 N informix phydbs
1bf84ad8 6 0x2001 6 1 N T informix tmpdbs
1bf84c20 7 0x11 7 1 N B informix blobdbs
1bf84d68 8 0x1 8 6 N informix idxdbs
8 active, 2047 maximum
Waiting for server to update BLOB chunk statistics...
Chunks
address chk/dbs offset size free bpages flags pathname
1bc02918 1 1 0 12800 11308 PO- D:IFMXDATArootdbs_dat.000
1bc6bb08 2 2 0 524032 322 PO- D:IFMXDATAdatadbs_dat.000
1bc6bc70 3 3 0 12800 11886 11886 POS D:IFMXDATAsbspace_dat.000
Metadata 861 556 861
1bc02c20 7 7 0 524032 16374 16376 POB D:IFMXDATAblobdbs_dat.000
23 active, 2047 maximum
[/code]
请高人指点,谢谢