What’s a very large script?
That’s a subjective question, and the answer will depend somewhat on the hardware specs of your machine.
I got this question yesterday:
@thatjeffsmith is there a limit to the number of lines I can paste into the code editor in SQL developer?
— louise mcscootash (@metalouise) September 12, 2014
I enjoy these questions. They’re 99% of the time, not theoretical. She had obviously ran into some sort of wall.
And the wall looked like this:
@thatjeffsmith I've got an insert script generated by the Import Data tool with aforementioned 600k records but it won't open the file.
— louise mcscootash (@metalouise) September 12, 2014
There’s no real answer – like I said before, it ‘depends.’ But 600,000+ statements – our editor wasn’t designed to handle files of that size.
If you were to look at what Notepad does to a file on open compared to what we do on files on open and even as you type, click, and scroll – you would understand why.
So, what’s one to do when you want to run those INSERTs?
![Just reference the file with the '@' SQL*Plus syntax and execute.](https://www.thatjeffsmith.com/wp-content/uploads/2014/09/Screen-Shot-2014-09-13-at-8.32.18-AM.png)
One More Tip
It will run even faster if you minimize the script output panel – no need for the tool to write 600k+ update messages to the display…
For very large files like this, you’ll want to make sure you log the output to a secondary file, so consider adding a SPOOL to your script.
2 Comments
great you saved my time. Thanks from SENEGAL.
Excellent! And thanks for the feedback.