Question

How to know when operations happened on a table?

Answer 1

In the database, FLASHBACK_TRANSACTION_QUERY shows all information about flashback transaction queries.

SELECT *

FROM flashback_transaction_query

WHERE TABLE_NAME

AND table_owner

and operation

order by start_timestamp desc