SQL*Loader DISCARDMAX Parameter

This parameter specifies the maximum number of discard records can be allowed during a particular data load. This is a number parameter and if you are not specifying any number for this argument then it will consider all discard records. Otherwise it will exit the data load once it reaches the limit. See an example below
Here is my data file

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer