Informix 12.10.FC14
Solaris 10 1/13
I have in-table simple large objects (both TEXT and BYTE). I want to move them to a distinct blob space.
I started with a small table that contains only a few TEXT objects. Here is excerpt from oncheck -pT:
TBLspace Report for doc:wmoriart.cmpct_invst
Physical Address 1:3324768
Creation date 05/19/2010 14:34:03
TBLspace Flags c01 Page Locking
TBLspace contains TBLspace BLOBs...Type Pages Empty Semi-Full Full Very-Full
---------------- ---------- ---------- ---------- ---------- ----------
Free 5
Bit-Map 1
Index 0
Data (Home) 10
TBLspace BLOBs 16 0 1 7 8 ----------
Total Pages 32
I ran an 'ALTER TABLE <table> MODIFY(<column> TEXT IN<blobspace>);' command.
It seems to have worked. The blob space was newly created and empty. After the ALTER command, 'oncheck -pe' shows it is no longer empty (although the number of pages doesn't match the number of BLOB pages that oncheck -pT showed before I did the ALTER.
Also, oncheck -pT for the source table now shows
no entry for "TBLspace BLOBs" (previously was 16, see above). But, the heading information still reports:
"TBLspace contains TBLspace BLOBs"Why is this? I think all the TEXT objects formerly in the same dbspace as the table are now in a new blob space. If they are not, I would also ask "why", and what do I need to do to move them to the blob space.
Thank you.
DG
------------------------------
David Grove
------------------------------
#Informix