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