lob – Learning is not a spectator sport

How to migrate to SECUREFILE with DataPump

These tweets somewhat befuddle me. Because to be honest, if I no matter if I say “Yes” or “No” ,

We had an interesting question on AskTOM the other day about LOB compression. Someone was very concerned that after applying

Just a quick tip for SECUREFILE lobs. You may be familiar with basic compression on data in tables. It is

I’ve got two words to describe my thoughts on being lazy with data types …. JUST DON’T! There’s been many

There was a time, many moons ago when CLOB, BLOB and BFILE did not exist as data types. So if

This has always been a nuisance. There you are – getting all the bells and whistles with LOBs…until a database

This one caught me out – I was racing around looking for bugs, or parameter files, or hidden settings that

In a previous post, I noted that the parameter db_securefile changes from PERMITTED in 11g, to PREFERRED in 12c. Jonathan

I observed this idiosyncracy recently when loading some lob from external files using PL/SQL: First we’ll create a file to

Some folks still are stuck with LONG columns, and are keen to move to LOB. Since version 9, we’ve had