BL_LOAD_METHOD=

BL_LOAD_METHOD=

Specifies the method by which data are loaded into an ORACLE table.

Default value: INSERT when loading an empty table; APPEND when loading a table that contains data

Syntax

Syntax

BL_LOAD_METHOD= INSERT | APPEND | REPLACE | TRUNCATE

INSERT | APPEND | REPLACE | TRUNCATE: A method with which to load data into an ORACLE table.

Details

When you load data into a empty ORACLE table, the default method is INSERT. When you load data into an ORACLE table that already contains data, the default method is APPEND.

The REPLACE and TRUNCATE values apply only when you are loading data into a table that already contains data. In this case, you can use REPLACE and TRUNCATE to override the default value of APPEND. Refer to the Oracle utilities documentation for information about using the TRUNCATE and REPLACE load methods.

To specify BL_LOAD_METHOD=, you must first specify YES for the option BULKLOAD=.

Chapter Contents
Previous
Next
Top of Page