Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Execute 650 mb sql script

Re: Execute 650 mb sql script

From: Gump <phefford_at_gmail.com>
Date: 10 Apr 2005 19:25:12 -0700
Message-ID: <1113186312.250242.127890@o13g2000cwo.googlegroups.com>


Another point... check that you don't have blank trailing spaces on every line of your script.

This can occur when you dynamically build a script. Refer to the SQL*Plus setting TRIMSPOOL.

This can drastically reduce the size of the outputted file. Received on Sun Apr 10 2005 - 21:25:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US