Oracle7 Server Utilities

Preface

This manual describes how to use the following Oracle7 Server utilities for data transfer, maintenance, and database administration.

Export/Import Export and Import are two complementary programs that constitute a single utility. Export writes data from an Oracle database into transportable files. Import reads data from those files back into an Oracle database. These utilities help you back up data, upgrade to new releases of the Oracle Server, and move data between Oracle databases.
SQL*Loader The SQL*Loader utility loads data from external files into Oracle database tables. SQL*Loader processes a wide variety of input file formats and gives you control over how records are loaded.
NLS Utilities The NLS Configuration Utility allows you to configure your boot files so that only the NLS objects that you require will be loaded.
Offline Database Verification (DB_VERIFY) DB_VERIFY is an external command-line utility that performs a physical data structure integrity check on an offline database. It can be used against backup files and online files (or pieces of files). You use DB_VERIFY primarily when you need to insure that a backup database (or datafile) is valid before it is restored or as a diagnostic aid when you have encountered data corruption problems. Because DB_VERIFY can be run against an offline database, integrity checks are significantly faster.

This manual describes the basic concepts behind each utility and provides examples to show how the utilities are used.

Some of the information this manual provides must be supplemented for the high-security version of the Oracle7 Server, Trusted Oracle7 Server. Such information is marked with references to the Trusted Oracle7 Server documentation.

Export/Import	Export and Import are two complementary programs that constitute a single utility. Export writes data from an Oracle database into transportable files. Import reads data from those files back into an Oracle database. These utilities help you back up data, upgrade to new releases of the Oracle Server, and move data between Oracle databases.
SQL*Loader	The SQLLoader utility loads data from external files into Oracle database tables. SQLLoader processes a wide variety of input file formats and gives you control over how records are loaded.
NLS Utilities	The NLS Configuration Utility allows you to configure your boot files so that only the NLS objects that you require will be loaded.
Offline Database Verification (DB_VERIFY)	DB_VERIFY is an external command-line utility that performs a physical data structure integrity check on an offline database. It can be used against backup files and online files (or pieces of files). You use DB_VERIFY primarily when you need to insure that a backup database (or datafile) is valid before it is restored or as a diagnostic aid when you have encountered data corruption problems. Because DB_VERIFY can be run against an offline database, integrity checks are significantly faster.