Database Error Messages

SQL*Loader-00222

invalid option specified for DEFAULTS parameter

Cause

An invalid value was specified for the DEFAULTS parameter.


Action

Specify one of the following values:

  • IGNORE to disable loading of default values.
  • EVALUATE_ONCE to load default values, but evaluate default expressions once at the beginning of the load.
  • EVALUATE_EVERY_ROW to load default values and evaluate default expressions for each row.
  • IGNORE_UNSUPPORTED_EVALUTE_ONCE to load default values where supported, ignore otherwise. Evaluate defaults once.
  • IGNORE_UNSUPPORTED_EVALUTE_EVERY_ROW to load default values where supported, ignore otherwise. Evaluate defaults every row.