Specifying the dumpfile modifier tells the load utility the name and the location of the exception file to which rejected rows are written. When running in a partitioned database environment, the name is given an extension that identifies the partition number where the exceptions were generated. For example:
dumpfile = "/u/usrname/dumpit"
On partition zero, this will generate a file named /u/usrname/dumpit.000. On partition five, it will generate a file named /u/usrname/dumpit.005, and so on.
Only the first 32 768 bytes of a record are written into the dump file; the rest is discarded.
For more information about load file type modifiers, see File Type Modifiers (Load).