It is possible to system column - timestamp - in Oracle table to find out just when was it transformed before?

I'd assume there has to be someone to let pad sights pull changes only ...

Oracle uses System Change Number (SCN). You have access to it inside a query as ora_rowscn. However, automatically it signifies time the whole block was modified not really a particular row. If you would like row level information, your table should be produced using the rowdependencies specifier.

And you're simply making incorrect presumptions about how exactly materialized sights work. Oracle monitors changes using tables MLOG$ and $RUPDS.