Do Oracle materialized view records get timestamp automatically?

Do Oracle materialized开发者_开发百科 view records get timestamp automatically?

The date of the last refresh for a materialized view is held in ALL_MVIEWS.LAST_REFRESH_DATE (or USER_MVIEWS.LAST_REFRESH_DATE).

Oracle materialized view records do not get a timestamp automatically. However, a System Change Number (SCN) can be included with each record by adding "ORA_ROWSCN AS SCN" to the select statement. System Change Numbers (SCN) provide a row version number and are updated when the row is updated.