# Max number rows for Import? **URL:** \ **Category:** Toad for Oracle - Beta\ **Created:** [July 13, 2015, 1:35pm UTC](https://forums.toadworld.com/t/max-number-rows-for-import/33747 "2015-07-13T13:35:03Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![phyllis.helton\_1150](https://avatars.discourse-cdn.com/v4/letter/p/ac8455/32.png) [@phyllis.helton\_1150](https://forums.toadworld.com/u/phyllis.helton_1150)\ **Post date:** [July 13, 2015, 1:35pm UTC](https://forums.toadworld.com/t/max-number-rows-for-import/33747/1 "2015-07-13T13:35:03Z")
I have a huge tab-delimited text file that I’m trying to import. There are 145,247 rows, no header. One of the fields is very large, it is allowed to hold up to 10,000 characters. (I am not importing that particular field.) I have tried to import the file multiple ways, and each time, TOAD acts like the import was successful, yet each time I only get a fraction of the rows. Once 12k, once 29k, once 31k, but never more than that. I have checked the data in the file around the last row that imported, and not only does the data not match up, but there doesn’t appear to be any problem with the text file. I have converted it to a different encoding. . . (One example is that the data in the text file appears to be sorted by country code and then ascending city name, but the imported data appears to be sorted by country code and then descending order by city name.) Is there a limit to how many rows I can import using the import wizard? Do I need to work with our DBAs to data pump this data in? Blessings, Phyllis – **Phyllis Helton** Data Magician Digital Strategies, Cru | Data Sciences & Analytics Office ☎ 407-515-4452 [phyllis.helton@cru.org](mailto:phyllis.helton@cru.org) ![](http://emailassets.cru.org/cdn-crumail/cru.png) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [July 13, 2015, 1:39pm UTC](https://forums.toadworld.com/t/max-number-rows-for-import/33747/2 "2015-07-13T13:39:47Z")
Hi Phyllis, There shouldn’t be any real limit. I’ve imported millions of rows. Are you importing with the Array DML option? If so, one bad row will prevent the entire array (default 500 rows) from importing. So you might try the non-Array-DML option and see if you get any specific errors. If you can send me the file and table DDL, I’ll be happy to try to help diagnose and fix the problem. -John ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [July 13, 2015, 1:46pm UTC](https://forums.toadworld.com/t/max-number-rows-for-import/33747/3 "2015-07-13T13:46:57Z")
A couple more thoughts: 1. if you can’t send the entire file, maybe we can reproduce the problem with a portion of it (and sensitive fields removed or replaced with junk data) 2. It should never act like everything worked fine if some rows are failing to import. 3. Does it shed any light if you check “Log errors”? ---
**Author:** ![phyllis.helton\_1150](https://avatars.discourse-cdn.com/v4/letter/p/ac8455/32.png) [@phyllis.helton\_1150](https://forums.toadworld.com/u/phyllis.helton_1150)\ **Post date:** [July 14, 2015, 4:39am UTC](https://forums.toadworld.com/t/max-number-rows-for-import/33747/4 "2015-07-14T04:39:20Z")
Thanks John. I'll send you the file and the ddl for the table privately. It is a free data source, so there is no problem sending you the entire thing. When I turn logging on, I don't get any log. I haven't used the Array DML, so it isn't that. I appreciate your help with this. 🙂 On Mon, Jul 13, 2015 at 4:49 PM, John Dorlon [bounce-jdorlon@toadworld.com](mailto:bounce-jdorlon@toadworld.com) wrote: > **[RE: Max number rows for Import?](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/25016/55083#55083)** > Reply by John Dorlon > A couple more thoughts: > 1. if you can't send the entire file, maybe we can reproduce the problem with a portion of it (and sensitive fields removed or replaced with junk data) > 1. It should never act like everything worked fine if some rows are failing to import. > 1. Does it shed any light if you check "Log errors"? > To reply, please reply-all to this email. > > [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/25016?subscribe=false) on this subject. > > Or [Unsubscribe from Toad for Oracle - Beta](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86?subscribe=false) notifications altogether. > > Toad for Oracle - Beta Discussion Forum > [Flag](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/25016/55083?AbuseContentId=a1751a8c-3916-4176-945f-370d5fb987c0&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. > ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif) -- **Phyllis Helton** Data Magician Digital Strategies, Cru | Data Sciences & Analytics Office ☎ 407-515-4452 [phyllis.helton@cru.org](mailto:phyllis.helton@cru.org) ![](https://global.discourse-cdn.com/quest/original/3X/9/4/94bf0c4f5e9dec7932932b0cb0b94169a403b1fd.png)