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