Oracle7 Server Utilities

Specifying RECOVERABLE and UNRECOVERABLE

The following options apply to direct path loads:

RECOVERABLE Loaded data is logged in the redo log. This option is the default for direct path loads. All conventional loads are recoverable.
UNRECOVERABLE This option can be specified for a direct path load only. Loaded data is not logged, which improves load performance. (Other changes to the database are logged.) For details, see "Specifying UNRECOVERABLE" . This option cannot be specified with a conventional load.

RECOVERABLE	Loaded data is logged in the redo log. This option is the default for direct path loads. All conventional loads are recoverable.
UNRECOVERABLE	This option can be specified for a direct path load only. Loaded data is not logged, which improves load performance. (Other changes to the database are logged.) For details, see "Specifying UNRECOVERABLE" . This option cannot be specified with a conventional load.