Out of memory error on Import Table Data when data in spreadsheet field is longer than column size.
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.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.