An ORACLE table is loaded with a DATALOAD statement containing the keyword ORACLE after the INFILE specification. For security reasons, the integer representation used in the EXP file (INTEGER LOHI) should be specified as well. Descriptions of fields can be used if the definition of the ORACLE table is not identical to that of the table to be loaded. The position specification in the field descriptions must denote the sequence numbers of the columns in the original table. It is not necessary to load all columns into the new table. It is possible to load constants or values of functions.
Example:
DATALOAD TABLE reservation
resnumber SEQNO
date SYSDATE
customername 2
city 4
INFILE ora_res.exp
ORACLE INTEGER LOHI
In this case, LOAD expects such a file generated using the ORACLE function EXP as for the LOAD ORACLEDB statement. This file, however, should not contain more than one table. If more tables are stored in the EXP file, LOAD attempts to use the first occurring data block for the loading.