Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: securefile
LOBs and tiny typos
This one caught me out – I was racing around looking for bugs, or parameter files, or hidden settings that stopped SECUREFILE lobs from being created. Here was my incredibly simple test case – create a securefile LOB, and then make sure it’s a…
Securefile in 12c – part 2
In a previous post, I noted that the parameter db_securefile changes from PERMITTED in 11g, to PREFERRED in 12c. Jonathan Lewis raised the interesting question of what happens when you upgrade to 12c from 11g, where a partitioned table may already have some basicfile…
CLOBS, from 11g to 12c
If you are a regular user of LOB’s in the database, take care when you switch from 11g to 12c. Notice the subtle difference: In 11g, you are permitted to, and recommended to, use SECUREFILE lobs, but they are not the default SQL> select…
