Table of Contents
- Title and Copyright Information
- Preface
- 1 Introduction to Large Objects and SecureFiles
-
2
Persistent LOBs
- 2.1 Creating a Table with LOB Columns
-
2.2
Inserting and Updating LOB Values in
Tables
- 2.2.1 Inserting and Updating with a Buffer
- 2.2.2 Inserting and Updating by Selecting a LOB From Another Table
- 2.2.3 Inserting and Updating with a NULL or Empty LOB
-
2.2.4
Inserting and Updating with a LOB
Locator
- 2.2.4.1 PL/SQL: Inserting a Row by Initializing a LOB Locator Bind Variable
- 2.2.4.2 JDBC (Java): Inserting a Row by Initializing a LOB Locator Bind Variable
- 2.2.4.3 OCI (C): Inserting a Row by Initializing a LOB Locator Bind Variable
- 2.2.4.4 Pro*C/C++ (C/C++): Inserting a Row by Initializing a LOB Locator Bind Variable
- 2.2.4.5 Pro*COBOL (COBOL): Inserting a Row by Initializing a LOB Locator Bind Variable
- 2.3 Selecting LOB Values from Tables
- 2.4 Performing DML and Query Operations on LOBs in Nested Tables
- 2.5 Performing Parallel DDL, Parallel DML (PDML), and Parallel Query (PQ) Operations on LOBs
- 2.6 Sharding with LOBs
- 3 Temporary LOBs
- 4 BFILEs
- 5 SQL Semantics for LOBs
- 6 PL/SQL Semantics for LOBs
-
7
Data Interface for LOBs
- 7.1 Overview of the Data Interface for LOBs
- 7.2 Benefits of Using the Data Interface for LOBs
- 7.3 Data Interface for LOBs in Java
-
7.4
Data Interface for LOBs in OCI
- 7.4.1 Binding a LOB in OCI
- 7.4.2 Defining a LOB in OCI
- 7.4.3 Multibyte Character Sets Used in OCI with the Data Interface for LOBs
- 7.4.4 Getting LOB Length
- 7.4.5 Using OCI Functions to Perform INSERT or UPDATE on LOB Columns
- 7.4.6 Using OCI Data Interface to Fetch LOB Data
- 7.4.7 PL/SQL and C Binds from OCI
- 8 Locator Interface for LOBs
- 9 Distributed LOBs
- 10 Performance Guidelines
-
11
Persistent LOBs: Advanced DDL
-
11.1
Creating a New LOB Column
- 11.1.1 CREATE TABLE BNF
- 11.1.2 ENABLE or DISABLE STORAGE IN ROW
- 11.1.3 CACHE, NOCACHE, and CACHE READS
- 11.1.4 LOGGING and FILESYSTEM_LIKE_LOGGING
- 11.1.5 The RETENTION Parameter
- 11.1.6 SecureFiles Compression, Deduplication, and Encryption
- 11.1.7 BasicFile Specific Parameters
- 11.1.8 Restriction on First Extent of a LOB Segment
- 11.1.9 Summary of CREATE TABLE LOB Storage Parameters for Securefile LOBs
- 11.2 Altering an Existing LOB Column
- 11.3 Creating an Index on LOB Column
- 11.4 LOBs in Partitioned Tables
- 11.5 LOBs in Index Organized Tables
-
11.1
Creating a New LOB Column
-
12
Advanced Design Considerations
-
12.1
Read-Consistent Locators
- 12.1.1 A Selected Locator Becomes a Read-Consistent Locator
- 12.1.2 Example of Updating LOBs and Read-Consistency
- 12.1.3 Example of Updating LOBs Through Updated Locators
- 12.1.4 Example of Updating a LOB Using SQL DML and DBMS_LOB
- 12.1.5 Example of Using One Locator to Update the Same LOB Value
- 12.1.6 Example of Updating a LOB with a PL/SQL (DBMS_LOB) Bind Variable
- 12.1.7 Ensuring Read Consistency
-
12.2
LOB Locators and Transaction Boundaries
- 12.2.1 About LOB Locators and Transaction Boundaries
- 12.2.2 Read and Write Operations on a LOB Using Locators
- 12.2.3 Selecting the Locator Outside of the Transaction Boundary
- 12.2.4 Selecting the Locator Within a Transaction Boundary
- 12.2.5 LOB Locators Cannot Span Transactions
- 12.2.6 Example of Locator Not Spanning a Transaction
- 12.3 LOBs in the Object Cache
- 12.4 Guidelines for Creating Terabyte sized LOBs
-
12.1
Read-Consistent Locators
- 13 Managing LOBs: Database Administration
- 14 Migrating Columns to SecureFile LOBs
- 15 Introducing the Database File System
-
16
Using DBFS
- 16.1 DBFS Installation
- 16.2 Creating a DBFS File System
-
16.3
DBFS File System Access
- 16.3.1 DBFS Client Prerequisites
- 16.3.2 Multiple Mount Points on DBFS Client
- 16.3.3 Manager File System
- 16.3.4 DBFS Client Command-Line Interface Operations
-
16.3.5
DBFS Mounting Interface (Linux and Solaris Only)
- 16.3.5.1 Installing FUSE on Solaris 11 SRU7 and Later
- 16.3.5.2 Solaris-Specific Privileges
- 16.3.5.3 About the Mount Command for Solaris and Linux
- 16.3.5.4 Mounting a File System with a Wallet
- 16.3.5.5 Mounting a File System with Password at Command Prompt
- 16.3.5.6 Unmounting a File System
- 16.3.5.7 Mounting DBFS Through fstab Utility for Linux
- 16.3.5.8 Mounting DBFS Through the vfstab Utility for Solaris
- 16.3.5.9 Restrictions on Mounted File Systems
- 16.3.5.10 Restrictions on Types of Files Stored at DBFS Mount Points
- 16.3.6 File System Security Model
- 16.3.7 HTTP, WebDAV, and FTP Access to DBFS
- 16.4 DBFS Administration
- 16.5 Shrinking and Reorganizing DBFS Filesystems
-
17
DBFS SecureFiles Store
- 17.1 Setting Up a SecureFiles Store
- 17.2 Using a DBFS SecureFiles Store File System
- 17.3 About DBFS SecureFiles Store Package, DBMS_DBFS_SFS
- 17.4 Database File System (DBFS)— POSIX File Locking
- 18 DBFS Hierarchical Store
-
19
Database File System Links
- 19.1 About Database File System Links
- 19.2 Ways to Create Database File System Links
- 19.3 Database File System Links Copy
- 19.4 The DBMS_LOB Package Used with DBFS
- 19.5 DBMS_LOB Constants Used with DBFS
- 19.6 DBMS_LOB Subprograms Used with DBFS
- 19.7 Copying a Linked LOB Between Tables
- 19.8 Online Redefinition and DBFS Links
- 19.9 Transparent Read
-
20
DBFS Content API
- 20.1 Overview of DBFS Content API
- 20.2 Stores and DBFS Content API
-
20.3
Getting Started with DBMS_DBFS_CONTENT Package
- 20.3.1 DBFS Content API Role
- 20.3.2 Path Name Constants and Types
- 20.3.3 Path Properties
- 20.3.4 Content IDs
- 20.3.5 Path Name Types
- 20.3.6 Store Features
- 20.3.7 Lock Types
- 20.3.8 Standard Properties
- 20.3.9 Optional Properties
- 20.3.10 User-Defined Properties
- 20.3.11 Property Access Flags
- 20.3.12 Exceptions
- 20.3.13 Property Bundles
- 20.3.14 Store Descriptors
-
20.4
Administrative and Query APIs
- 20.4.1 Registering a Content Store
- 20.4.2 Unregistering a Content Store
- 20.4.3 Mounting a Registered Store
- 20.4.4 Unmounting a Previously Mounted Store
- 20.4.5 Listing all Available Stores and Their Features
- 20.4.6 Listing all Available Mount Points
- 20.4.7 Looking Up Specific Stores and Their Features
- 20.5 Querying DBFS Content API Space Usage
- 20.6 DBFS Content API Session Defaults
- 20.7 DBFS Content API Interface Versioning
- 20.8 DBFS Content API Creation Operations
- 20.9 DBFS Content API Deletion Operations
- 20.10 DBFS Content API Path Get and Put Operations
- 20.11 DBFS Content API Rename and Move Operations
- 20.12 Directory Listings
- 20.13 DBFS Content API Directory Navigation and Search
- 20.14 DBFS Content API Locking Operations
- 20.15 DBFS Content API Access Checks
- 20.16 DBFS Content API Abstract Operations
- 20.17 DBFS Content API Path Normalization
- 20.18 DBFS Content API Statistics Support
- 20.19 DBFS Content API Tracing Support
- 20.20 Resource and Property Views
- 21 Creating Your Own DBFS Store
- 22 DBFS Access Using OFS
- A Comparing the LOB Interfaces