0

I'm relatively new to Oracle SQL and trying to import CSVs using SQL Developer. I've been getting errors such as

Insert failed for rows 1351 through 1400

ORA-01438: value larger than specified precision allowed for this column

Is there a way to determine the Columns that this error message concerns (?), so I can examine the values in the CSVs to see what is causing the error and how I should change the DDL.

Thanks!

1

Set the preview window higher, default is 100 rows.

enter image description here

Then we can validate more during the preview.

enter image description here

You can scroll the preview window's worth of data, and each column value for each row will get validated via the column definition in the data.

Or, set the import type to insert script, and run the script in a worksheet.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.