Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Related Documents
  • Conventions
• Oracle® AI Database Lakehouse
  • How to Use this Guide
    • Use this Guide in this Order
    • Scope and Conventions
    • Deployment and Capability Matrix
• Lakehouse Basics
  • Understand the Lakehouse Architecture
    • Distinguish Data Ownership and Product Boundaries
  • Select the Correct Oracle Access Pattern
    • Separate Metadata Access from Data Access
    • Respect Feature and Deployment Boundaries
    • Use the Enterprise and Operational Catalogs for Different Jobs
    • Design for Remote I/O
• Setup and Access
  • Plan the Deployment and Access Model
    • Confirm the Deployment Capabilities
    • Preflight Example
    • Understand the Access Model
  • Configure Connectivity and Database Access
    • Configure Outbound Network and TLS
    • Grant Least-Privilege Database Access
  • Plan Authentication and Credential Responsibilities
    • Separate Credential Roles
    • Choose a Provider Authentication Model
  • Create and Map Credential Objects
    • Create and Own Credential Objects
    • Map Catalog and Storage Credentials
  • Maintain and Troubleshoot Access
    • Rotate and Revoke Credential
    • Diagnose the Failing Layer
• Catalogs, Governance, and Enterprise Data Access
  • Understand the Enterprise Catalog Landscape
    • Distinguish the Catalog Layers
    • Use an Enterprise Catalog Service for Cross-System Discovery
    • Understand the Catalog Architecture
  • Mount Catalogs in Each Database
  • Maintain Catalog Authority and Metadata Freshness
    • Preserve System of Records
    • Manage Metadata Freshness at the Correct Layer
  • Govern Access and Choose the Operational Path
    • Apply Governance Without Duplicating Authorization
    • Continue with the Operational Path
• Working with Iceberg Tables
  • Understand and Choose an Iceberg Access Model
    • Understand the Iceberg Model and Read Path
    • Choose an Access Model
    • Understand the Metadata Objects
  • Read Iceberg Tables
    • Direct Metadata Access
    • Mounted Catalog Access
    • Vector Search on External Iceberg Tables (Vector on Ice)
  • Operate and Troubleshoot Iceberg Read Access
    • Understand Read-Path Limitations
    • Diagnose Iceberg Access
  • Create and Manage Iceberg Tables with Oracle SQL
    • Use Oracle-managed Create and Write Operations
    • Understand Ownership and Persistence
    • Prepare the Catalog and Storage
    • Mount the Certified Catalog Implementation
    • Create an Iceberg Table from Oracle SQL
    • Insert Data with INSERT … SELECT
    • Insert into an Existing Iceberg Table
    • Complete the Transaction and Refresh Visibility
    • Write to Iceberg Tables with Overridden Column Data Types
    • Update Iceberg Tables
    • Delete Iceberg Tables
    • Drop an Iceberg Table Created Through Oracle
  • Partition Iceberg Tables
    • Partition Transforms
    • Create Iceberg Partitions with PARTITION BY Clause
    • Write Partition Iceberg Tables
    • Partition Visibility
    • Drop Partition Iceberg Table with PURGE Clause
    • Transaction Recovery
  • Plan Interoperability and Related Serving Patterns
    • Interoperability in Release 26.3 and above
    • Supported Types and Physical Format
    • Table Properties for Iceberg Tables
    • Transaction, Naming, and SQL Restrictions
    • Coordinate Cross-Engine Access
• External Files and External Tables
  • Plan External Data Access
    • Choose the SQL Access Path
    • Understand the External-Table Contract
    • Select an Access Driver and Source Format
  • Query Files with External Tables
    • Create and Query a Persistent External Table
    • Query an Inline External Table
  • Query Data through a Mounted Catalog
  • Access Shared Data with Delta Sharing
  • Manage Source Layouts and Changes
    • Map Partitioned File Layouts
    • Handle Source Changes
• Performance Considerations
  • Performance Model and Diagnostics
    • Inspect the Executed Plan
  • Non-Iceberg External Data
    • File format, columns, and predicates
    • Folder Layout and Partition Pruning
    • File Size and File Count
    • Statistics and Cardinality
    • Parallel Query
    • Select-the-Execution-Strategy
  • Iceberg Tables
    • Iceberg Scan Planning
    • Partition and Schema Evolution
    • Metadata and File Maintenance
    • Metadata Cache and Lake Cache
    • Oracle Iceberg Access Paths
  • Lake Cache
    • Scope, Behavior, and Use Cases
    • Prerequisites, Storage, and Resources
    • Choose the Management Model
    • Policy-based Cache lifecycle
    • Automatic Cache Lifecycle
    • Monitor and Diagnose
    • Mounted Catalog and Iceberg Tables
    • Freshness and Failure Behavior
  • Symptom-to-Action Guide
  • Detailed References