TEMP_EXTRACT_SWAP Option

In combination with the TEMP_EXTRACT_BINARY option, specifies the type of extraction performed by the data extraction facility.

Allowed values

ON, OFF

Default

OFF

Scope

Can be set for an individual connection. Takes effect immediately.

Description

Use this option with the TEMP_EXTRACT_BINARY option to specify the type of extraction performed by the data extraction facility.

Extraction Option Settings for Extraction Type
Extraction type	TEMP_EXTRACT_BINARY	TEMP_EXTRACT_SWAP
binary	ON	OFF
binary/swap	ON	ON
ASCII	OFF	OFF

The default extraction type is ASCII.

For details on the data extraction facility and using the extraction options, see System Administration Guide: Volume 1 > Data Import and Export > Methods of Exporting Data from a Database > Data Extraction Facility.