Using the Tools | Import | Import Wizard to import data from Excel file to a table results in the following error:
ORA-24381: error(s) in array DML
One or more fields of the source file has larger size than the VARCHAR field size entered in the Import Wizard.
The number one reason that causes this error is that the data for a column is not compatible with that column type. IE: Length of varchar is too long for column def, nonnumeric into numeric column, etc.
