after i deleted a records from Message Viewer thru BSI client, i noted it deleted from 2 tables: bsirun and bsimesa.
i tried to:
SQL> delete from bsirun where rundate=20140925; delete from bsirun where rundate=20140925 * ERROR at line 1: ORA-02292: integrity constraint (TF10.SYS_C004589166) violated - child record found
it won't let me due to bsirun ties up to bsimesa. i need to find a way to delete from bsimesa. bsimesa has no unique field for me to delete.
if anyone has done this, would you like to share ?
reason - i want to automate this process so i don't have to login to BSI client, and delete them daily/weekly/monthly.