RE: Trace file does not list detailed timings

From: M.Godlewski <mcgodlewski_at_yahoo.com>
Date: Mon, 30 Jan 2006 11:03:31 -0800 (PST)
Message-ID: <20060130190332.98926.qmail@web42008.mail.yahoo.com>

Oracle 9iR2
  Sun Solaris    

  List,    

  I have a long in a table sent over via (DTS sqlserver) to my Oracle instance that I converted to a clob    

  alter table tablename modify( Description clob);    

  I then use sqlplus to pull information from the table and create a csv file. When I pull all the columns other then description (my clob) column, I am able to create a csv file without weird page breaks.    

  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.    

  pagesize 0
  linesize 32767
  long 32767
  feedback off
  verify off
  echo off    

  I've started at substr(a.description, 1,10) and am working by way up to try to find what is the problem setting, but is it slow.    

  If anyone has ideas or docs I would appreciated the help! I imagine it is a sql limitation of some sort.    

  TIA
  M.Godlewski                             

---

Bring words and photos together (easily) with  PhotoMail - it's free and works with Yahoo! Mail.
--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 30 2006 - 13:03:31 CST