List of Examples

• 2-1 Performing a Table-Mode Export
• 2-2 Data-Only Unload of Selected Tables and Rows
• 2-3 Estimating Disk Space Needed in a Table-Mode Export
• 2-4 Performing a Schema Mode Export
• 2-5 Parallel Full Export
• 2-6 Stopping and Reattaching to a Job
• 3-1 Performing a Data-Only Table-Mode Import
• 3-2 Performing a Schema-Mode Import
• 3-3 Network-Mode Import of Schemas
• 6-1 Performing a Simple Schema Export
• 6-2 Importing a Dump File and Remapping All Schema Objects
• 6-3 Using Exception Handling During a Simple Schema Export
• 6-4 Displaying Dump File Information
• 7-1 Loading Data in Fixed Record Format
• 7-2 Loading Data in Variable Record Format
• 7-3 Loading Data in Stream Record Format
• 9-1 Sample Control File
• 9-2 Identifying XMLType Tables in the SQL*Loader Control File
• 9-3 CONTINUEIF THIS Without the PRESERVE Parameter
• 9-4 CONTINUEIF THIS with the PRESERVE Parameter
• 9-5 CONTINUEIF NEXT Without the PRESERVE Parameter
• 9-6 CONTINUEIF NEXT with the PRESERVE Parameter
• 10-1 Field List Section of Sample Control File
• 10-2 DEFAULTIF Clause Is Not Evaluated
• 10-3 DEFAULTIF Clause Is Evaluated
• 10-4 DEFAULTIF Clause Specifies a Position
• 10-5 DEFAULTIF Clause Specifies a Field Name
• 11-1 Loading Column Objects in Stream Record Format
• 11-2 Loading Column Objects in Variable Record Format
• 11-3 Loading Nested Column Objects
• 11-4 Loading Column Objects with a Subtype
• 11-5 Specifying Attribute Nulls Using the NULLIF Clause
• 11-6 Loading Data Using Filler Fields
• 11-7 Loading a Column Object with Constructors That Match
• 11-8 Loading a Column Object with Constructors That Do Not Match
• 11-9 Using SQL to Load Column Objects When Constructors Do Not Match
• 11-10 Loading an Object Table with Primary Key OIDs
• 11-11 Loading OIDs
• 11-12 Loading an Object Table with a Subtype
• 11-13 Loading System-Generated REF Columns
• 11-14 Loading Primary Key REF Columns
• 11-15 Loading LOB Data in Predetermined Size Fields
• 11-16 Loading LOB Data in Delimited Fields
• 11-17 Loading LOB Data in Length-Value Pair Fields
• 11-18 Loading LOB DATA with One LOB per LOBFILE
• 11-19 Loading LOB Data Using Predetermined Size LOBs
• 11-20 Loading LOB Data Using Delimited LOBs
• 11-21 Loading LOB Data Using Length-Value Pair Specified LOBs
• 11-22 Loading Data Using BFILEs: Only File Name Specified Dynamically
• 11-23 Loading Data Using BFILEs: File Name and Directory Specified Dynamically
• 11-24 Loading a VARRAY and a Nested Table
• 11-25 Loading a Parent Table with User-Provided SIDs
• 11-26 Loading a Child Table with User-Provided SIDs
• 12-1 Setting the Date Format in the SQL*Loader Control File
• 12-2 Setting an NLS_DATE_FORMAT Environment Variable
• 14-1 Specifying the PREPROCESSOR Clause
• 14-2 Using the PREPROCESSOR Clause with a Shell Script
• 20-1 Using the DBMS_METADATA Programmatic Interface to Retrieve Data
• 20-2 Using the DBMS_METADATA Browsing Interface to Retrieve Data
• 20-3 Retrieving Multiple Objects
• 20-4 Placing Conditions on Transforms
• 20-5 Modifying an XML Document
• 20-6 Using Parse Items to Access Specific Metadata Attributes
• 20-7 Using the Submit Interface to Re-Create a Retrieved Object
• 20-8 Retrieving Heterogeneous Object Types
• 20-9 Filtering the Return of Heterogeneous Object Types
• 20-10 Comparing Object Metadata