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

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

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.