Re: Execute 650 mb sql script

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Sun, 10 Apr 2005 16:16:18 +0200
Message-ID: <d3bc93$1q0$1@news5.zwoll1.ov.home.nl>

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
>

You cannot. Probably.

SQL*Plus used to be 32kB as maximum, now (10g) 64kB, I think. That is one statement, mind you, so every ';' or better yet: '/' ends the statement.

How do you get such large scripts?!? And what is exactly the error message?

-- 
Regards,
Frank van Bortel

Received on Sun Apr 10 2005 - 09:16:18 CDT