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

5-1 Performing a Simple Schema Export

5-2 Importing a Dump File and Remapping All Schema Objects

5-3 Using Exception Handling During a Simple Schema Export

6-1 Loading Data in Fixed Record Format

6-2 Loading Data in Variable Record Format

6-3 Loading Data in Stream Record Format

8-1 Sample Control File

8-2 Identifying XML Type Tables in the SQL*Loader Control File

8-3 CONTINUEIF THIS Without the PRESERVE Parameter

8-4 CONTINUEIF THIS with the PRESERVE Parameter

8-5 CONTINUEIF NEXT Without the PRESERVE Parameter

8-6 CONTINUEIF NEXT with the PRESERVE Parameter

9-1 Field List Section of Sample Control File

9-2 DEFAULTIF Clause Is Not Evaluated

9-3 DEFAULTIF Clause Is Evaluated

9-4 DEFAULTIF Clause Specifies a Position

9-5 DEFAULTIF Clause Specifies a Field Name

10-1 Loading Column Objects in Stream Record Format

10-2 Loading Column Objects in Variable Record Format

10-3 Loading Nested Column Objects

10-4 Loading Column Objects with a Subtype

10-5 Specifying Attribute Nulls Using the NULLIF Clause

10-6 Loading Data Using Filler Fields

10-7 Loading a Column Object with Constructors That Match

10-8 Loading a Column Object with Constructors That Do Not Match

10-9 Using SQL to Load Column Objects When Constructors Do Not Match

10-10 Loading an Object Table with Primary Key OIDs

10-11 Loading OIDs

10-12 Loading an Object Table with a Subtype

10-13 Loading System-Generated REF Columns

10-14 Loading Primary Key REF Columns

10-15 Loading LOB Data in Predetermined Size Fields

10-16 Loading LOB Data in Delimited Fields

10-17 Loading LOB Data in Length-Value Pair Fields

10-18 Loading LOB DATA with One LOB per LOBFILE

10-19 Loading LOB Data Using Predetermined Size LOBs

10-20 Loading LOB Data Using Delimited LOBs

10-21 Loading LOB Data Using Length-Value Pair Specified LOBs

10-22 Loading Data Using BFILEs: Only Filename Specified Dynamically

10-23 Loading Data Using BFILEs: Filename and Directory Specified Dynamically

10-24 Loading a VARRAY and a Nested Table

10-25 Loading a Parent Table with User-Provided SIDs

10-26 Loading a Child Table with User-Provided SIDs

11-1 Setting the Date Format in the SQL*Loader Control File

11-2 Setting an NLS_DATE_FORMAT Environment Variable

18-1 Using the DBMS_METADATA Programmatic Interface to Retrieve Data

18-2 Using the DBMS_METADATA Browsing Interface to Retrieve Data

18-3 Retrieving Multiple Objects

18-4 Placing Conditions on Transforms

18-5 Modifying an XML Document

18-6 Using Parse Items to Access Specific Metadata Attributes

18-7 Using the Submit Interface to Re-Create a Retrieved Object

18-8 Retrieving Heterogeneous Object Types

18-9 Filtering the Return of Heterogeneous Object Types