List of Tables

1-1 DBA_DATAPUMP_JOBS View and USER_DATAPUMP_JOBS View

1-2 The DBA_DATAPUMP_SESSIONS View

2-1 Original Export Parameters and Their Counterparts in Data Pump Export

2-2 Supported Activities in Data Pump Export's Interactive-Command Mode

3-1 Original Import Parameters and Their Counterparts in Data Pump Import

3-2 Supported Activities in Data Pump Import's Interactive-Command Mode

5-1 Valid Job States in Which DBMS_DATAPUMP Procedures Can Be Executed

7-1 Exit Codes for SQL*Loader

8-1 Parameters for the INFILE Keyword

8-2 Parameters for the CONTINUEIF Clause

8-3 Fixed-Length Fields

8-4 Nongraphic Fields

8-5 Graphic Fields

8-6 Variable-Length Fields

9-1 Parameters for the Position Specification Clause

9-2 Datatype Conversions for Datetime and Interval Datatypes

9-3 Parameters Used for Specifying Delimiters

9-4 Parameters for the Field Condition Clause

9-5 Behavior Summary for Trimming Whitespace

9-6 Parameters Used for Column Specification

12-1 Case Studies and Their Related Files

17-1 Parameters for the DBNEWID Utility

18-1 DBMS_METADATA Procedures Used for Retrieving Multiple Objects

18-2 DBMS_METADATA Procedures Used for the Browsing Interface

18-3 DBMS_METADATA Procedures and Functions for Submitting XML Data

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

20-2 Privileges Required to Import Grants

20-3 Objects Exported and Imported in Each Mode

20-4 Sequence of Events During Updates by Two Users

20-5 Maximum Size for Dump Files

20-6 Exit Codes for Export and Import

20-7 Using Different Releases of Export and Import

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