14 Managing LOBs: Database Administration
You must perform various administrative tasks to set up, maintain, and use a database that contains LOBs.
Note:
LOBs are not supported when the Container Database root and Pluggable Databases are in different character sets. For more information, refer to Relocating a PDB Using CREATE PLUGGABLE DATABASE.- Initialization Parameter for SecureFiles LOBs
As a database administrator, you can configure the conditions that control or allow creation of SecureFiles LOBs or BasicFiles LOBs. Typically, you set up theDB_SECUREFILEparameter in theinit.orafile for this purpose. - Database Character Set Considerations
The database character set cannot be changed from a single-byte to a multibyte character set if there are populated user-definedCLOBcolumns in the database tables. - Database Utilities for Loading Data into LOBs
Certain utilities are recommended for bulk loading data into LOB columns as part of the database set up or maintenance tasks. - LOB Migration with Data Pump
- BFILEs Management
This section describes various administrative tasks to manage databases that containBFILEs. - Managing LOB Signatures
This section describes how to configure LOB signatures.