How Oracle Text DR$ Index Table Entries Appear in the Audit Trail
The UNIFIED_AUDIT_TRAIL data dictionary view lists actions on audited Oracle Text DR$ index tables.
For example:
SELECT ACTION_NAME, OBJECT_SCHEMA, DBUSERNAME FROM UNIFIED_AUDIT_TRAIL
WHERE OBJECT_NAME = 'DR$EMP_DATA_IDX$I';
ACTION_NAME OBJECT_SCHEMA DBUSERNAME
----------- ------------- ----------
UPDATE PRESTON FUSFERATU