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.
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.
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.