RE: Make BLOBS go into the BLOB space
I don't know about trying this with an alter... but the final structure s/b like:
create table wds_store
(
wds_blob_id serial not null ,
wds_blob byte in new_blobspace, -- new blob space name
wds_mime varchar(50),
wds_desc varchar(50),
wds_blob_size char(12)
default '0',
primary key (wds_blob_id)
);
I've never tried this, but 'alter' maybe something like:
alter table wds_store modify
wds_blob byte in new_blobspace ;
-----Original Message-----
From: Adam Williams [mailto:adam@morrison-ind.com]
Sent: Thursday, June 19, 2003 1:40 PM
To: Informix-List (E-mail)
Subject: Make BLOBS go into the BLOB space
I have a table -
create table wds_store
(
wds_blob_id serial not null ,
wds_blob byte,
wds_mime varchar(50),
wds_desc varchar(50),
wds_blob_size char(12)
default '0',
primary key (wds_blob_id)
);- that is taking up alot of space in our primary dbspace.
So I create a blobspace as outlined in the manual.
But I can't find any information on making the blobspace be utilized.
Do I need to drop and recreate this table to force the blobs over there,
or is there some alter statement I can perform?
sending to informix-list
**********************************************************************
Privileged/Confidential information may be contained in this message.
If you are not an addressee indicated in this message (or responsible
for delivery of the message to such person[s]), you may not copy or
deliver this message to anyone. If you have received this message in
error, you should destroy and delete it from your computer and notify
the sender by reply email. Opinions, conclusions and other information
in this message that do not relate to the official business of
Diversified Collection Services shall be understood as neither given
nor endorsed by the company. Accordingly, Diversified Collection
Services disclaims all responsibility and accepts no responsibility for
the consequences of any person(s) acting, or refraining from acting,
on such information prior to the receipt by that person(s) of
subsequent written confirmation.
**********************************************************************
sending to informix-list