I created a materialized table in Virtual DataPort, which allows me to perform insertion operations into it. But when I tried to perform deletion of the table’s data from VirtualDataPort, then it throws a “**Delete on materialized tables is not allowed**” error. This is the expected behavior because Materialized Tables allow performing only the insert operations.
For your scenario, I would check the Oracle logs to identify the user who executed the Delete statement. Also, if I had the [**Denodo monitor**](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/monitoring_the_virtual_dataport_server/denodo_monitor/denodo_monitor) launched, I would check the Denodo Monitor log files to determine whether any query was triggered from the Virtual DataPort at that particular time.
Hope this helps!