SQLPLUS Spool - Truncating Data

I am running a SQL script in Solaris 9 to export data from an Oracle DB using spool. However, for one particular field, the data is getting truncated. Can anyone explain why this is happening or how I can fix it??

Original Data:

Code:

---

14Oct06 1459L/LC[[Called the helpdesk call center for update.  They forwared me to the monitoring center.  The monitoring center states that their ticket isnt closed yet.

---

Spool file:

Code:

---

14Oct06 1459L/LC[[Called the helpdesk call center fo

---

My SQL script

Code:

---

set colsep*
set heading off
set feedback off
set pagesize 0
set linesize 30000
set trimspool off
spool oracle.txt
SELECT *
FROM aradmin.CIRCUIT_OUTAGE_F
ORDER BY ENTRY_ID ASC;
spool off

---

Did you try:

col text_field format a1000
???

I just tried that and it still gives the same results

Is it a LONG or a CLOB or something?

Set long 10000

It is a CLOB

The SET long 10000 seemed to work well, but it caused another problem. I use * for column seperators and it seems that it puts * whenever the data starts on a new line.

Example:

Code:

---

14Oct06 1459L/LC[[Called the helpdesk call c                *
enter for update.  They * forwared me to the monitoring      *  *  center.  The mon                                *itoring center states that their ticket isnt c*  *                      losed yet.

---