Re: Smart Large Objects: Sbspace is full
I suggest adding new chunks to img_db01, img_db02 dbspaces and no new
dbspaces.
I don't know how you have been able to add a new table with the same name.
You should be used ALTER TABLE.
Regards, Guillermo.
----- Original Message -----
From: "Mark" <kbl@net-yan.com>
To: <informix-list@iiug.org>
Sent: Sunday, May 25, 2003 1:05 PM
Subject: Smart Large Objects: Sbspace is full
> At first, I created following table to store PDF data in column img_doc.
>
> create table img
> (
> img_key varchar(40),
> img_no integer,
> img_doc "informix".blob,
> ) PUT img_doc in
> (
> img_db01,
> img_db02
> );>
> Sometimes later, SBspace img_db01 and img_db02 were full. Therefore, I
> added other new SBspace img_db03 and img_db04 to the column.
>
> create table img
> (
> img_key varchar(40),
> img_no integer,
> img_doc "informix".blob,
> ) PUT img_doc in
> (
> img_db01,
> img_db02,
> img_db03,
> img_db04
> );>
> Sometime later, when I insert row to the table. I got following
message.
>
> 9810: Smart-large-object error.
> 12031: Smart Large Objects: Sbspace is full.>
> I found that the first 2 SBspace are full but img_db03 and img_db04 are
> still have a lot of space.
>
> Can I balance the data in the four SBspaces except to delet and re-insert
> all the row?
>
>
>
>
>