Re: Execute 650 mb sql script

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 10 Apr 2005 14:43:58 -0700
Message-ID: <1113169213.249752_at_yasure>


bhawin13_at_indiatimes.com wrote:

> Hello,
> I have 650 mb sql script. how to run such big size script sucessfully.
> I have 1 gb ram.
>
> I have tried it with sql*plus, toad and object browser. But during
> loading script all hangs and at last it gives memory error.
>
> Is there anyway to run such large script?
>
> Thanks,
> bhawin13

No Oracle version.
No hardware information except RAM
No operating system information
No information on SGA size
No explanation as to what the script does or how it could possibly be so large.
No actual error message to consider
No crystal ball, taro cards, or lucky rabbits foot No help possible

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sun Apr 10 2005 - 23:43:58 CEST

Original text of this message