Using Multiple BLOB Columns

From: JMecc <jmecc_at_telus.net>
Date: 17 Sep 2006 13:34:17 -0700
Message-ID: <1158525257.822755.182000@i3g2000cwc.googlegroups.com>

I am trying to create a table with more than one [large] BLOB field in it. With one BLOB, I can store as:

create table multiblob (

LastName	char(20),
FirstName	char(20),
Age		integer,
Pic		BLOB,

PRIMARY KEY (LastName, FirstName))
lob (Pic) store as glob_store (
storage (initial 6M next 6M pctincrease 0)
);

with no problems, but when adding a second field:

create table multiblob (

LastName	char(20),
FirstName	char(20),
Age		integer,
Pic1		BLOB,
Pic2		BLOB,

PRIMARY KEY (LastName, FirstName))
lob (Pic1, Pic2) store as glob_store (
storage (initial 6M next 6M pctincrease 0)
);

this gives me the error: ORA-22855: optional name for LOB storage segment incorrectly specified

What is the proper syntax to declare the storage parameters for multiple BLOB's?

Thanks,
Jo Received on Sun Sep 17 2006 - 15:34:17 CDT