Database Administration (MOSC)

MOSC Banner

Creating table with user defined type as securefile

edited Aug 16, 2019 5:01AM in Database Administration (MOSC) 3 commentsAnswered

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)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center