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>
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