Out of memory error on Import Table Data when data in spreadsheet field is longer than column size. (4304047)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Out of memory error on Import Table Data when data in spreadsheet field is longer than column size.
Description

A table is defined with an nvarchar2(2000) column. The spreadsheet has a column of text to load into that table/column. Text in the spreadsheet, however, is longer than 2000 characters. Even with Trim option selected in Import Table Data, Toad produces an out of memory error.
Resolution

WORKAROUND

Reduce text in spreadsheet to 2000 characters prior to import

STATUS

Issue is fixed in version 11.6.1. The latest version can be downloaded from here.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title