Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

What's New in Oracle Database SecureFiles and Large Objects Developer's Guide?

1 Introduction to Large Objects

Part I Getting Started

2 Working with LOBs

3 Managing LOBs: Database Administration

Part II SecureFiles LOBs

4 Using Oracle SecureFiles LOBs

5 Introducing the Oracle Database File System

6 DBFS File System Client

7 DBFS Content API

8 DBFS SecureFiles Store

9 DBFS Hierarchical Store

10 Creating a DBFS Store

Part III Application Design

11 LOB Storage

12 Advanced Design Considerations

13 Overview of Supplied LOB APIs

14 Performance Guidelines

Part IV SQL Access to LOBs

15 DDL and DML Statements with LOBs

16 SQL Semantics and LOBs

17 PL/SQL Semantics for LOBs

18 Migrating Columns from LONGs to LOBs

Part V Using LOB APIs

19 Operations Specific to Persistent and Temporary LOBs

20 Data Interface for Persistent LOBs

21 LOB APIs for BFILE Operations

22 Using LOB APIs

A LOB Demonstration Files

Glossary

Index