You can use the access parameters to modify the default behavior of theĪccess driver. Parameters unique to external tables of the type ORACLE_LOADER. The ORACLE_LOADER access driver provides a set of access When identifiers (for example, column or table names) are specified in the external table access parameters, certain values are considered to be reserved words by the access parameter parser. Reserved Words for the ORACLE_LOADER Access Driver.This section lists restrictions to be aware of when you use the ORACLE_LOADER access driver.

Restrictions When Using the ORACLE_LOADER Access Driver.This topic describes some performance hints when using the ORACLE_LOADER access driver. Performance Hints When Using the ORACLE_LOADER Access Driver.The ORACLE_LOADER access driver attempts to divide large data files into chunks that can be processed separately. Parallel Loading Considerations for the ORACLE_LOADER Access Driver.

The optional ORACLE_LOADER access drive COLUMN TRANSFORMS clause provides transforms that you can use to describe how to load columns in the external table that do not map directly to columns in the data file. In the field_definitions clause, you use the FIELDS parameter to name the fields in the data file and specify how to find them in records. Learn how to parse, label and manage record information with the record_format_info clause and its subclauses. The access_parameters clause contains comments, record formatting, and field formatting information. The ORACLE_LOADER access driver provides a set of access parameters unique to external tables of the type ORACLE_LOADER.

Free Disk Sorter Ultimate 15.3.12