Toad World® Forums

TOAD 10.6.1.3 SECUREFILE VARRAY bug in DDL generator


#1

Hi folks,

I noticed that when I create a table using SECUREFILE LOB storage for a VARRAY
that the TOAD ddl generator misses the SECUREFILE keyword when
“scripting” the table.

For example:

CREATE TABLE foo_securefile(

foo SDO_GEOMETRY

)

VARRAY foo.SDO_ELEM_INFO STORE AS SECUREFILE LOB (

ENABLE STORAGE IN ROW

)

VARRAY foo.SDO_ORDINATES STORE AS SECUREFILE LOB (

ENABLE STORAGE IN ROW

);

When I “script” this table the results lack the SECUREFILE keyword.
It’s kind of a bummer as using the TOAD rebuild table utility means I lose
the SECUREFILE LOB storage.

I double checked that

SELECT securefile FROM user_lobs WHERE table_name = ‘FOO_SECUREFILE’

Shows YES for both LOBs.

Cheers,

Paul


#2

Sorry for bumming you out, Paul. It will be fixed in Today’s beta. :slight_smile: