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