Yes, Toad can execute scripts with multiple insert statements. I am not sure what is going wrong there, but running a script full of insert statements will
not be as fast as the Insert Table Data wizard.
Go back to Insert Table Data, use the “apply to database object” option, and be sure to choose the “Use Array DML” option under it. That will give you the
fastest possible import speed.
From: gwoods [mailto:email@example.com]
Sent: Wednesday, July 10, 2013 7:27 AM
Subject: [Toad for Oracle - Discussion Forum] Toad 220.127.116.11 Access Violation when importing data
Toad 18.104.22.168 Access Violation when importing data
Thread created by gwoods
I am trying to use the Import Table Data functionality to import data from an Excel sheet into a data warehouse table.
As I’m connecting to a data warehouse over a limited WAN connection, using the ‘Apply changes to the database object’ is taking far too long so I tried to use the ‘Create file with SQL statements’
There are essentially 30,000 rows in the Excel data set so the SQL statement is quite large.
However when running the SQL statement I getting an access violation message in Toad.exe and it aborts the run.
Surely Toad can handle this many multiple insert statements in a script?
Any help would be greatly appreciated.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.