Toad for Oracle Editor – How to Run Very Large Scripts

One from Wendy Penfold on the Toad lists:

Hi, I need to load a large file of insert statements–44,000. The file is too large to open in the Toad editor, it hangs Toad. Is there a way I can run the script without opening it in the editor? Thanks! Wendy

A number of replies were received from the developers guys, and they all said very much the same thing :

• In the MOE, simply type @c:\path\to\script\script_name.sql
• then press F5.

Alternatively, it can be run in QSR (Quest Script Runner) using exactly the same command.