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 Transparent Data Encryption (TDE) will recognize the encryption options.

I can’t see the old-style (BasicFile) LOBs lasting very long now this is in place. :)

Cheers

Tim…

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 most closely matches the method used by external tables.

Cheers

Tim…

BLOBs and External Tables…

 

A 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 and he was still using 9i. :(

Cheers

Tim…