How to set commit interval after n rows when generating insert statements?
471182Jul 26 2009 — edited Jul 27 2009Hi
I'm trying to generate a sql insert script with a few million rows using SQL Developer 1.5.4.
I can generate insert scripts ok, but can't see anywhere to set the commit interval.
In the preferences screen under migration I see you can set the commit interval under data move options, but I assume this is something different.
I know we could use sql loader, but this insert is part of deployment package which has a series of sql scripts that we need to run together. So I don't want to run a series of sql scripts, then run sql loader, and then go back to sql scripts.
Am i missing something, or is this just not possible with SQL Developer?
Thanks in advance for your help,
Pete