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