Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

What's New in Database Utilities?

Part I Oracle Data Pump

1 Overview of Oracle Data Pump

2 Data Pump Export

3 Data Pump Import

4 Data Pump Performance

5 The Data Pump API

Part II SQL*Loader

6 SQL*Loader Concepts

7 SQL*Loader Command-Line Reference

8 SQL*Loader Control File Reference

9 SQL*Loader Field List Reference

10 Loading Objects, LOBs, and Collections

11 Conventional and Direct Path Loads

Part III External Tables

12 External Tables Concepts

13 The ORACLE_LOADER Access Driver

14 The ORACLE_DATAPUMP Access Driver

Part IV Other Utilities

15 ADRCI: ADR Command Interpreter

16 DBVERIFY: Offline Database Verification Utility

17 DBNEWID Utility

18 Using LogMiner to Analyze Redo Log Files

19 Using the Metadata API

20 Original Export and Import

21 Enterprise Manager Configuration Assistant (EMCA)

Part V Appendixes

A SQL*Loader Syntax Diagrams

Index