Introduction
~~~~~~~~~~~~
This is a short note on the internal storage of LOBs. The information
here is intended to supplement the documentation and other notes
which describe how to use LOBS. The focus is on the storage characteristics
and configuration issues which can affect performance.
There are 4 types of LOB:
CLOB, BLOB, NCLOB stored internally to oracle
BFILE stored externally
The note mainly discusses the first 3 types of LOB which as stored INTERNALLY
within the oracle DBMS. BFILE’s are pointers to external files and
are only mentioned briefly.
Examples of handling LOBs can be found in Note 47740.1
继续阅读 »
近期评论