Oracle related rants (and lots of off-topic stuff)…
In today’s video we’ll demonstrate the SecureFiles Shrink feature, introduced in Oracle database 21c.
The video is based on this article.
You might also find these useful.
The star of today’s video is Arman Sharma. This clip was from Sangam15. To think that was seven years ago is mind-blowing!
Cheers
Tim…
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…
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…
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…