Import Table Data, Import Failed with following error: Out of Memory
While trying to do an IMPORT TABLE DATA immediately generates generic "Out of Memory" error
The Import is a Text file approximately 1 GB.
There is a resource limitation of Windows when using the Table Data Import feature in Toad when importing the size flat file you are importing.
When using an IMPORT of this size, the Flat Table Import feature is ineffective due to overuse of memory buffer-gets within the Windows OS and the Toad GUI that causes Toad to generate the Memory error.
This is the reason for the SQL Loader feature being available within Toad.
RESOLUTION #1:
Try the import on another machine. There is a case history that the resolution was determined to be machine specific.
RESOLUTION #2:
Use SQL Loader Wizard. Under Import menu you will see the SQL Loader wizard that uses Oracle's SQL Loader to import the data.
RESOLUTION #3:
Import small file at a time. I.e. export data to multiple files and run import on each small file, or export data to 2003 Excel so that data is broken down into separate sheets, but in one .xls file. When importing table data, choose to import a few sheets at a time.
Excel 2003's limit is about 65,000 rows per sheet.
No Defect ID number since it is a Windows OS memory limitation.
There has been a Toad technical writing request to document these Windows OS memory limitations when using the Table Data Import within the Help Section.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center