If the max size over 2M
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: If the max size over 2M

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

    If the max size over 2M

    Thank you!

    I went to Metalink and got the solution -- to change the parameter file -- /$oraclehome/sysman/config/omsconfig.properties.

    set up a new parameter, the MAX is 2M.
    oms.vdg.job_output_maxsize=2M

    But my output is larger than 2M, how can I do?

    -Betty

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

    Question is here -

    Sorry, above question is based on below question and "Bazza"'s answer --

    "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

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

    Solution Here --

    Hi,

    I got solution, just put "set termout off" in the spool script file, then all output result will not be display on the output file.

    for example:
    try.sql
    -- set termout off;
    spool t.txt;
    select empno from emp;
    spool off;
    set termout on;

    The call @try.sql through OEM job. Then the output size will not go beyond 2M.

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