Re: Execute 650 mb sql script

From: Lewis C <lewisc_at_excite.com>
Date: Sun, 10 Apr 2005 23:06:20 GMT
Message-ID: <avbj511emvb4gosrrg58f7f1tophkvi2o7@4ax.com>

On 10 Apr 2005 07:07:04 -0700, bhawin13_at_indiatimes.com wrote:

>Hello,
>I have 650 mb sql script.
>When i am executing it with sql* plus or toad or object browser its get
>hanged and at last it fails.
>
>i have 1 gb ram.
>Can anybody tell me how can i run such large script.
>
>Thanks,
>bhawin13

I've run sql scripts that were upwards of 10 or 20 megs. They were discrete insert statements. Is that what you're doing?

It may take a while to execute depending on what you're doing. Also depending on the commands that run, you may not get any feedback until the script completes. Run it and see if sql*plus is getting any activity in task manager.

Post the first 25 lines and the last 25 lines and let us get a view of what you're running.

Toad isn't good for this kind of script because it has to load the entire script into memory (in the sql window). I've not used object browser. sqlplus doesn't have this limitation, as long as the script isn't a giant pl/sql block.

But post a portion of the script and maybe we can figure out how to run it.

Lewis

Lewis R Cunningham

Author, ItToolBox Blog: An Expert's Guide to Oracle http://blogs.ittoolbox.com/oracle/guide/

Topic Editor, Suite101.com: Oracle Database http://www.suite101.com/welcome.cfm/oracle

Received on Sun Apr 10 2005 - 18:06:20 CDT