Re: Execute 650 mb sql script

bhawin13_at_indiatimes.com wrote:

>I have 650 mb sql script. how to run such big size script sucessfully.
>I have 1 gb ram.

[Quoted] [Quoted] I'm not sure whether this will work or not, but when I was doing a project, I put the scripts for all the different tables into different files and then launched a "mother-script" which went through all of the different files (with regular COMMITS) - maybe this might work?

How often do you COMMIT during the script? If never, then this *_may_* [Quoted] be the problem. I would *_assume_* that most of the script is of the nature of INSERT INTO TableBlah VALUES (blah1, blah2..... blahn).

Try putting "COMMIT;" at the end of every block of 5000 or so records? Or even at the end of each completed table entry?

Better still if you figure out how to do this programatically - I'm not familiar enough yet with the Oracle tools to be able to give you an answer to this.

Paul...

>bhawin13

-- 

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2, 

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.2.0;

When asking database related questions, please give other posters 
some clues, like operating system and version of db being used.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
 
Furthermore, As a courtesy to those who spend 
time analyzing and attempting to help, please 
do not top post.