Export Dataset Issues

Toad for Oracle
1

I’m trying to export my dataset, but getting the following error: “Access violation at address 0000000000404D0A in module ‘Toad.exe’. Read of address 00000000FE720018”

How do I resolve this?

Thanks in advance!

2

I need more information:

  1. What version of Toad are you using?

  2. Does it matter which export format you use or do you get it with all of them?

  3. Does it matter which table you export or do you get it with all of them?

3

Hi John,

I’m using version 11.6.0.43, and I only receive the error when trying to export as an excel file. I seem to only get the error when trying to export a large dataset (200,00+ records)

Thanks,

Richard

On Apr 11, 2017, at 12:15 PM, John Dorlon bounce-jdorlon@toadworld.com wrote:

RE: Export Dataset Issues

Reply by John Dorlon
I need more information:

  1. What version of Toad are you using?
  1. Does it matter which export format you use or do you get it with all of them?
  1. Does it matter which table you export or do you get it with all of them?

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle Forum notifications altogether.
Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

4

what version of Excel are you using. Some version have a limit of 65,nnn rows and if you are trying to export 200,nnn rows Excel may be hanging and stopping.

5

Toad should move to another sheet if you try to export more rows than is allowed per sheet.

With that many rows, you might be running out of memory. Make sure that the “Display all results in grid” option is UNCHECKED. That will make Toad re-run the query in a way that doesn’t cache the results in memory (as it would for a grid, so you can scroll backwards).

6

Using Excel 2013, so the limit is 1M+ rows

On Apr 12, 2017, at 4:55 AM, Mark Kurtz bounce-Mark_Kurtz@toadworld.com wrote:

RE: Export Dataset Issues

Reply by Mark Kurtz
what version of Excel are you using. Some version have a limit of 65,nnn rows and if you are trying to export 200,nnn rows Excel may be hanging and stopping.

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle Forum notifications altogether.
Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

7

That version of Toad was also released in 2012 (and is 8 versions old) so it’s possible that there is a compatibility issue. You should consider upgrading.