Informix

Expand all | Collapse all

Best reorganization ever in smartblobspaces

Jump to Best Answer
  • 1.  Best reorganization ever in smartblobspaces

    Posted 15 days ago
    Hello community!!.

    I have a table with a blob column stored in one smartblobspace which is growing hugely, I would like to know the best way to reorganize it trough several smartblobspaces. I know that MODIFY column with ALTER TABLE will be done, only to new records. Please tell me another way that unload/load it through new schema. Thanks.

    ------------------------------
    Jessica Flores
    ------------------------------


  • 2.  RE: Best reorganization ever in smartblobspaces
    Best Answer

    Posted 15 days ago
    Hi Jessica,

    I guess what you're asking is how you can move certain sblobs from one sbspace to another?

    You might find this article on how to move a table's sblobs helpful, as well as How to determine which sbspace an sblob resides in.

    HTH,
     Andreas

    ------------------------------
    Andreas Legner
    ------------------------------



  • 3.  RE: Best reorganization ever in smartblobspaces

    Posted 12 days ago
    Thanks Andreas!

    It works much better!!.. I appreciate your help.

    ------------------------------
    Jessica Flores
    ------------------------------