Tag Archives: lob

SecureFiles in Oracle 11g…

I’ve just posted an article on SecureFiles in Oracle 11g. It looks like Oracle have done a pretty good job of improving LOBs in 11g. Depending on the LOB contents, and provided you can cope with the processing overhead, you can certainly save some serious space using the compression and deduplication options. Anyone who’s used […]

Loading LOB Data Using SQL*Loader…

In a recent post I discussed the use of BLOBs and External Tables. As a result of that I thought I better take a look at how SQL*Loader copes with LOBs, so I wrote Loading LOB Data Using SQL*Loader. SQL*Loader has a number of methods for loading LOBs, but I focussed on the one that […]

BLOBs and External Tables…

This post on the Dizwell Forum made me realise I had never used either CLOBs or BLOBs with an external table, so I thought I would give it a go and wrote this article: External Tables Containing LOB Data Unfortunately, it didn’t help the guy on the forum as this functionality was introduced in 10g […]