This discussion is archived
5 Replies Latest reply: Dec 6, 2012 1:04 AM by 787789 RSS

Help me in creating script to check rows in a table

787789 Newbie
Currently Being Moderated
Hi,

I want to write a shell script which should run the sql statement (select count(*) from TRACKNTRACE.SSA_REPL_LOG;), and if the count(*) exceeds 600000, the error should be generated in alert log as : ORA-ERGO:“Golspie,Prodamp TRACKTRACE too high value, please stop the job, info on wiki”

Is there any way to achieve it. I have read from some notes though not a good practice to use : dbms_system.ksdwrt(1,'test'), I am not sure how will I achieve my result?


Regards,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points