Re: Execute 650 mb sql script

Does the platform you're running this script from support input redirection (e.g. unix, or windows running Cygwin)? If so, you should be able to run any script, no matter how long, by avoiding the file size limit on sqlplus using syntax like this:

cat myhugefile.sql | sqlplus me/mypassword_at_myserver > myoutput.txt

or like this:

sqlplus me/mypassword_at_myserver < myhugefile.sql > myoutput.txt Received on Mon Apr 11 2005 - 11:09:21 CDT