how to cleanup event database omi 10.xx

[mbrockbernd]

I want to clean up the event database but I can not find the tables in the database we have omi version 10.12

I use Internal Change Request QCCR1A14629:

OMi does not provide a tool to purge the event tables in the database. You can use opr-close-events and opr-archive-events but this may take a
long time if there are lots of events in the database (Internal Change Request QCCR1A146296).
Note 1: often the problems are not the number of entries in ALL_EVENTS but rather the HISTORY_LINE and EVENT_PROPERTY_CHANGE entries, so the "small" solution is to just cleanup those two tables

I want to use truncate table EVENT_PROPERTY_CHANGE;
commit; delete from HISTORY_LINE;
I can not find the above table in omi 10.x.
Which table should I use?

[Edward_C_OMi1]

Hello,

Unfortunately from support perspective the only possible way to do this are through the option mentioned by you above. We highly recommend do not go directly into the Database.

[mbrockbernd]

Hello,

I already tried it in the standard way, unfortunately this does not work..

I had found this solution but the tables are different in 10.xx.

I am looking for someone who knows what tables I need to clean in OMI 10.xx

[ramesh9]

Check whether you have table ALL_EVENTS under EVENT DB schema if you are using Oracle DB.