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:
Spool file: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.
My SQL scriptCode:14Oct06 1459L/LC[[Called the helpdesk call center fo
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




Reply With Quote