|Oracle9i Application Developer's Guide - Large Objects (LOBs)
Release 1 (9.0.1)
Part Number A88879-01
Frequently Asked Questions about LOBs, 7 of 12
Is the LOB index created for the LOB in the same tablespace as the LOB data?
The LOB index is created on the LOB column and it indexes the LOB data. The LOB index resides in the same tablespace as the locator.
promotion column could be defined and indexed as a BFILE, but if for example, a row is DELETEd, the Word document is removed with it when the promotion column is defined as BLOB, but it is not removed when the column is defined as a BFILE. Why?
We don't create an index for BFILE data. Also note that internal persistent LOBs are automatically backed up with the database whereas external BFILEs are not and modifications to the internal persistent LOB can be placed in the redo log for future recovery.
Which views can I query to find out about a LOB index?
For temporary LOBs, the LOB index information can be retrieved from the view, V$SORT_USAGE.