List of Tables

1-1  Objects Exported and Imported in Each Mode

1-2  Sequence of Events During Updates by Two Users

1-3  Maximum Size for Dump Files

1-4  Invoking Export Using the Interactive Method

1-5  Exit Codes for Export

1-6  Using Different Releases of Export and Import

2-1  Privileges Required to Import Objects into Your Own Schema

2-2  Privileges Required to Import Grants

2-3  Invoking Import Using the Interactive Method

2-4  Exit Codes for Import

4-1  Exit Codes for SQL*Loader

5-1  Parameters for the INFILE Clause

5-2  Parameters for CONTINUEIF

5-3  Fixed-Length Fields

5-4  Nongraphic Fields

5-5  Graphic Fields

5-6  Variable-Length Fields

6-1  Parameters for the Position Specification Clause

6-2  Datatype Conversions for Datetime and Interval Datatypes

6-3  Parameters for Termination and Enclosure Specification

6-4  Parameters for the Field Condition Clause

6-5  Behavior Summary for Trimming Whitespace

6-6  Parameters Used for Column Specification

10-1  Case Studies and Their Related Files

14-1  Parameters for the DBNEWID Utility

15-1  Procedures for the DBMS_METADATA Programmatic Interface

15-2  Procedures for the DBMS_METADATA Browsing Interface

B-1  DB2 Functions and Equivalent SQL*Loader Options

C-1  Symbols and Conventions for Backus-Naur Form Syntax