2008 acetone aio blade c3000 cleaning cs csUriQuery csUriStem database disposal filter flashback golf hp isapi iscsi letogolais log long mpio multipath oil oracle paint polystyrene purification query recovery recycler recycling select server solvent Stem table texas thinner timestamp togo togolais ufc unit Uri used virginia wash waste water windows

Oracle flashback query - find out what happened to data using timestamp

With flashback enabled on oracle, you can find out what happened, for example, this morning by running query SELECT * FROM TABLE AS OF TIMESTAMP (TRUNC(SYSTIMESTAMP) + INTERVAL '8' HOUR + INTERVAL '10' MINUTE) WHERE ID = 1

This is an invaluable tool as you can figure out how the data was modified. Of course sometimes the data is modified more frequently than one second and in that case you really should use different flashback query that replaces AS OF TIMESTAMP with AS OF SCN statement.

More info:

permanent link to article http://freecash.hogger.net/oracle_flashback_query_find_out_what_happened_to_data_using_timestamp