Re: Execute 650 mb sql script
From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 10 Apr 2005 14:42:02 -0700
Message-ID: <1113169097.535063_at_yasure>
>
>
>
> 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_*
> 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
Date: Sun, 10 Apr 2005 14:42:02 -0700
Message-ID: <1113169097.535063_at_yasure>
Paul wrote:
>
> bhawin13_at_indiatimes.com wrote:
>
>
>
>>I have 650 mb sql script. how to run such big size script sucessfully. >>I have 1 gb ram.
>
>
>
> 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_*
> 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
[Quoted] As IANAL_VISTA indicates ... a really bad idea.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Sun Apr 10 2005 - 23:42:02 CEST