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

This preface contains:

Changes in Oracle Database 12c Release 1 (12.1)

The following are changes in Oracle Database SecureFiles and Large Objects Developer's Guide for Oracle Database 12c Release 1 (12.1).

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 "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 "About 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.