|
[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]
|
Re: [Plug] is there a linesize limit??
|
511 is inded close to 512. in fact that iswhat caused me to think it may have
been a linux hassle. with no CRLF, it dumpas as one line andI thought a 512m byte
line may have caused Linux to blink..
However, it is an Oracle problem, in the UTL_File package, there is an overload
version of fopen (a function) which allows you to specify a lne size to 232K, and
it was set low..
Default on the original fopen spec 1022, and was changed in 8.06..
Peace,
Vale
Kyle Burton wrote:
> > First of all, my apologies for writing this from NT..
>
> I wouldn't have known unless you said. So...shame on you! :)
>
> > In Oracle 8i on GNU-Linux, trying to dump a 213K table to a file but
> > there are no CRLF breaks..
> > at 511 Bytes (characters) the thing blows up..
> > I don;'t think this is a Linux hassle, but I'm trying to be sure before
> > pursuing other resolutions..
>
> Filesystems don't care about the data you're trying to store in a file --
> they don't look at the data to see what you're putting in there. So to
> say it's a line break thing would be doubious.
>
> 511 bytes? That's strangely close to 512 - a power of 2 - 2 to the 9th.
> Is there some buffer size you have to set in oracle? How are you trying
> to dump the data? What software are you using?
>
> I know that Oralce tried to keep users from using sqlplus as a fully fledged
> reporting system by limiting the dbms_output function's maximum output size.
>
> k
>
> ------------------------------------------------------------------------------
> A language that doesn't affect the way you think about programming, is not
> worth knowing.
> -- Alan J. Perlis
> mortis@voicenet.com http://www.voicenet.com/~mortis
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Plug maillist - Plug@lists.nothinbut.net
> http://lists.nothinbut.net/mail/listinfo/plug
_______________________________________________
Plug maillist - Plug@lists.nothinbut.net
http://lists.nothinbut.net/mail/listinfo/plug
|
|