Creating table with user defined type as securefile
Hi!
We have a user defined type:
create type OurBlobType as object (blobID number(11),value BLOB)
and have been using this in tables like this:
create table blobStorage of OurBlobType (constraint blobStorage_pk primary key (blobID) using index)
Now we want to see if things will go faster when using securefile instead of the default basicfile for the blob. But how do we specify this?
We have tried:
create type OurBlobType as object (blobID number(11),value BLOB as securefile)
which seems to be invalid. So we went back to the old version:
create type OurBlobType as object (blobID number(11),value BLOB)