The large amounts of data stored in LOBs can have a significant effect on the storage characteristics of your Oracle database.
Oracle gives you several different ways to store data in a LOB.
One way to store large amounts of data externally is through the BFILE data type, which is used as a pointer to an external datafile. Data
stored in a BFILE can be read only by an Oracle database, but you can use the
procedures on the data in a BFILE where appropriate. Regardless of whether you choose to use in-line or out-of-line storage, your LOB data types have the same functional characteristics:
- The LOBs can participate in transactions.
- You can use all the same SQL operations.
- You can use the same
DBMS_LOB procedures for CLOB and NCLOB data types.
In the next lesson, you will learn how to convert LONG and LONG RAW data types to LOB data types.