Securefiles Storage Parameters / creating securefile LOBS - 19c
Hi
We are one of those late adpators to SECUREFILE LOBS. Our databse is 19.21 and all our current LOBS are BASICLOBS
We are working on a plan to
A) Create any new LOB segments as SECUREFILES
B) Migrate existing LOBS to SECUREFILES
Some questions on A
#1)
We can ensure we are creating new lobs as SECUREFILE by
a) using "STORE as SECUREFILE" while creating LOBS
b) set DB_SECUREFILE parameter to ALWAYS or FORCE?
Correct?
#2) What is the difference between enable storage in row VS disable storage in row?
If we create a table with SECUREFILE LOB using the following 2 variations does that has any impact as to if the LOB is stored as in row vs out of row?