Oracle7 Server Utilities

Contents Index Home Previous Next

How This Book Is Organized

This manual is divided into four parts:

Part I: Export/Import

Chapter 1: Export

This chapter describes how to use Export to write data from an Oracle database into transportable files. It discusses guidelines, export modes, interactive and command-line methods, parameter specifications, and incremental exports. It also provides several examples of Export sessions.

Chapter 2: Import

This chapter shows you how to use Import to read data from Export files into an Oracle database. It discusses guidelines, interactive and command-line methods, parameter specifications, and incremental imports. It also provides several examples of Import sessions.

Part II: SQL*Loader

Chapter 3: SQL*Loader Concepts

This chapter introduces SQL*Loader and describes its features. It also introduces data loading concepts. It discusses input to SQL*Loader, database preparation, and output from SQL*Loader.

Chapter 4: SQL*Loader Examples

This chapter presents case studies that illustrate some of the features of SQL*Loader. It demonstrates the loading of variable-length data, fixed-format records, a free-format file, multiple physical records as one logical record, multiple tables, and direct file loads.

Chapter 5: SQL*Loader Control File Reference

This chapter describes the data definition language (DDL) used by SQL*Loader to map data to Oracle format. It discusses creating the control file to hold DDL source, using the LOAD DATA statement, specifying data files, specifying tables and columns, and specifying the location of data.

Chapter 6: SQL*Loader Command-Line Reference

This chapter describes the command-line syntax used by SQL*Loader. It discusses the SQLLOAD command, command-line arguments, suppressing SQL*Loader messages, and sizing the bind array.

Chapter 7: SQL*Loader Log File Reference

This chapter describes the information contained in the log file.

Chapter 8: SQL*Loader Conventional and Direct Path Loads

This chapter describes the conventional path load method and the direct path load method-- a high performance option that significantly reduces the time required to load large quantities of data.

Part III: NLS Utilities

Chapter 9: National Language Support Utilities

This chapter describes three utilities: NLS Data Installation Utility, NLS Configuration Utility, and NLS Calendar Utility.

Part IV: Offline Verification Utility

Chapter 10: Offline Database Verification Utility

This chapter describes how to use the offline database verification utility, DB_VERIFY.

Appendix A: Changes in the Oracle7 Server Utilities

This appendix describes changes (by release number) to the Oracle7 Server utilities.

Appendix B: Reserved Words

This appendix lists words reserved for use by the Oracle7 Server utilities.

Appendix C: Notes for DB2/DXT Users

This appendix describes differences between the data definition language syntax of SQL*Loader and DB2 Load Utility control files. It discusses SQL*Loader extensions to the DB2 Load Utility, the DB2 RESUME option, options included for compatibility, and SQL*Loader restrictions.


Contents Index Home Previous Next