monline

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