-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|