Changes in This Release for Oracle Database SecureFiles and Large Objects Developer's Guide

New Features

• Support for enabling parallel DML operations on SecureFiles LOBs

  Parallel DML Support for SecureFiles LOBs is enhanced, providing improved performance.

  See "Parallel DML (PDML) Support for LOBs".

• SecureFiles LOBs is now the default LOB storage

  SecureFiles LOB is the default storage option for LOBs, instead of BasicFiles LOB. See "About LOB Storage" for details.

• Increased size limit for VARCHAR2, NVARCHAR2, and RAW data types

  With this release, the maximum size of SQL data types VARCHAR2, NVARCHAR2, and RAW change respectively from 4,000 bytes and 2,000 bytes to 32,767 bytes each. The corresponding PL/SQL data types remain at 32,767 bytes.

  See Oracle Database SQL Language Reference to determine how to handle this size change in your applications.

• Data Pump uses SecureFiles as default LOB storage

  When you import tables, you can recreate all LOB columns as SecureFiles LOBs, thus converting BasicFiles LOBs to SecureFiles LOBs as part of data pump imports.

  See "Using Oracle Data Pump to Transfer LOB Data".

• Support for HTTP, WebDAV, and FTP Access to DBFS

  SecureFiles supports components that enable HTTP, WebDAV, and FTP access to DBFS over the Internet, using various XML DB server protocols

  See "HTTP, WebDAV, and FTP Access to DBFS".

Other Changes

The following are additional changes in the release:

• Chapters 1 to 10 have been renumbered and the content reorganized and rewritten.