DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: "output truncate" in OEM job

  1. #1
    Join Date
    Feb 2004
    Location
    NYC
    Posts
    39

    "output truncate" in OEM job

    Hi,

    I have a script to spool a huge select result, for example:
    "spool result.txt;
    select * from emp;
    spool off;
    "
    The records are over 20000 lines.

    This script execute well through sql*plus command line, but when I use OEM job to run it, the job failed because of "output truncate".

    Could anyone has good idea?
    Thanks!

    -Betty

  2. #2
    Join Date
    Jul 2002
    Posts
    335
    Check metalink, there is a config file you can amend to up the default limit, but I can't for the life of me remember what it is.

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