1. SecureFiles and Large Objects Developer's Guide
  2. Distributed LOBs

9 Distributed LOBs

This section describes the ways in which you can work with LOB data in remote tables.

See Also:

Sharding with LOBs
  • Working with Remote LOBs in SQL and PL/SQL
    This section describes the SQL and PL/SQL functions that are supported on remote LOBs.
  • Using the Data Interface on Remote LOBs
    The data interface enables you to bind and define a CHARACTER buffer for a CLOB column and a RAW buffer for a BLOB column. This interface is supported for remote LOB columns too.
  • Working with Remote Locators
    You can select a persistent LOB locator from a remote table into a local variable and this can be done in any programmatic interface like PL/SQL, JDBC or OCI. The remote columns can be of type BLOB, CLOB or NCLOB.