Where did the sql_text go? 10g
I am chasing an alleged sql statement that updated 2 rows in a table..There is a total of 5 rows in the table.
I have wrote sql from sql to search every sqltext like field in data dictionary for occurrences of upper and lower update and uppper and lower versions of the table.
Auditing is not on for this table. Log Miner is Not enabled. Trigger based auditing is not enabled.
I would have given up at that point but I check the ora_rowscn on two rows and used scn_to_timestamp to get the values from dual;
It certainly appears that the ora_rowscn changed at the time of the alleged sql statement issuance.
0