About temporary LOBs

First you should read all the stuff in the standard Oracle docs. After that you can read these two pages with some less known details about temporary LOBs:
  1. Chapter 17: Handling large objects (LOBs) - this is an addendum to the book "Practical Oracle 8i - Building Efficient Databases"
  2. Temporary LOBs - this is a section of the "Oracle DBA Tips Corner" website