RE: Trace file does not list detailed timings
- From: "M.Godlewski" <mcgodlewski@xxxxxxxxx>
- To: cary.millsap@xxxxxxxxxx, jonathan@xxxxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 30 Jan 2006 11:03:31 -0800 (PST)
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.
Other related posts:
