-
Hi !
I want to trap all errors while my script is running. My script has sqlplus, exp,imp etc...
I want all errors in one file and then mail it to xyz.
Is anybody knows about user_errors table. When errors are recorded in that ? How I can make use of it ?
-
Echo all the actions of the scripts and capture into a log. When the script completed, have a job that mails the log to xyz. Simple, but could be complex depending upon what are all the scripts,tasks you are running and running at OS/DB level.
Reddy,Sam
-
User should be notify if and only if errors occurs during execution . It's unix script.
-
Recorded errors are what ? DB errors/OS errors ?
If system errors check for the return codes, database/sql errors check for possible failure errors. Use sed/awk and find the strings in the log that says the task is successfull or not.
Reddy,Sam
-
recorded errors are ORA error, PLSQL error , EXP error , IMP error. Yes I am trying now awk, sed.
if you send me syntes to use awk or sed
-
Bevare that with imp, exp and sqlldr some messages that you would expect to be piped to standard output (STDOUT)are actually written to standard error (STDERR) queue....
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
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
|