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.
解决办法
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.
