SQLPLUS Spool - Truncating Data
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: SQLPLUS Spool - Truncating Data

  1. #1
    Join Date
    Nov 2006
    Posts
    6

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,003
    Did you try:

    col text_field format a1000
    ???
    this space intentionally left blank

  3. #3
    Join Date
    Nov 2006
    Posts
    6
    I just tried that and it still gives the same results
    Last edited by ignignokt; 11-15-2006 at 02:30 PM.

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Is it a LONG or a CLOB or something?

    Set long 10000
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Nov 2006
    Posts
    6
    It is a CLOB

  6. #6
    Join Date
    Nov 2006
    Posts
    6
    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.
    Last edited by ignignokt; 11-15-2006 at 04:03 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width