TORALoader - Mode

[jrunyan]

I don't see any mention in the documentation which mode is used for TOraLoader. Is it Insert or Append? Can this be set at design time?

[Plash]

Do you mean the Insert and Append methods of TOraTable?

TOraLoader does not use TOraTable or TOraQuery to load data. TOraLoader loads data using the Direct Path Load interface or by executing INSERT statements.

[jrunyan]

The SQL*Loader section in the Oracle Utilities Manual has a section on loading non-empty Tables. The section "Table-Specific Loading Method" has a clause that ca be set to; APPEND, REPLACE, or TRUNCATE.

Append adds the records, Replace performs a Delete on the table and Truncate Truncates the table first. If none of these are set then the records are Inserted and if the table is not empty an error is thrown.

Since there is no similar "Loading Method" is it safe to assume that TOraLoader allways inserts records into an empty table?

[Plash]

TOraLoader always appends records to those that are already present in the table.