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.
If it is less than 32 768 bytes in length, the record is copied to the dump file in its entirety; if it is longer, a record fragment (including the final bytes of the record) is written to the file.
For more information about load file type modifiers, see File Type Modifiers (Load).