2 Persistent LOBs

A persistent LOB is a LOB instance that exists in a table row in the database. Persistent LOBs can be stored as SecureFiles or BasicFiles.

The term LOB can represent LOBs of either SecureFiles or BasicFiles type, unless the storage type is explicitly indicated. It can be either by name for both storage types, or by reference to archiving or linking, which only applies to the SecureFiles storage type. Oracle strongly recommends SecureFiles for storing and managing LOBs.

SecureFiles LOB storage is the default in the CREATE TABLE statement, if no storage type is explicitly specified. All new LOB columns use SecureFiles LOB storage by default, which is the recommended method for storing and managing LOBs. SecureFiles LOB storage is designed to provide great performance and scalability to meet or exceed the performance of traditional network file system. However, you must use BasicFiles LOB storage for LOB storage in tablespaces that are not managed with Automatic Segment Space Management (ASSM). SecureFiles LOBs can only be created in tablespaces managed with Automatic Segment Space Management (ASSM).