I am trying to read the log file given as text file.I need to take the count of success and fail lines and capture the reason for that, which is in the same line where we have succes and failure message.
eg.
20170506-09:20:38 Failed Refresh for MV: MV_SEARCH_FFL_HISTORY$A # Error Reason : ORA-00942: table or view does not exist
So i should get "MV_SEARCH_FFL_HISTORY" failed due to "ORA-00942: table or view does not exist".
Above two things under 2 new fields that is "Status" and "Cause"