Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Trace file does not list detailed timings
On 1/30/06, M.Godlewski <mcgodlewski_at_yahoo.com> wrote:
>
> Oracle 9iR2
> Sun Solaris
> Once I add substr(a.description,1,4000) to my select clause from the
> table, I seem to get page breaks where they are not wanted.
> ...
> If anyone has ideas or docs I would appreciated the help! I imagine it is
> a sql limitation of some sort.
>
There are CR/LF line terminators in the data coming from SQL Server. Modifying the DTS job to filter them would be the easiest method to correct, especially if the SQL Server DBA is someone other than yourself.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 31 2006 - 09:21:15 CST
![]() |
![]() |