This has been asked many times, but is there any new methods to find out the time when the row was inserted?
I have already tried to find out using ORA_ROWSCN. But its not accurate. It shows the updated date i believe and dose not show if the row is inserted before a long time.
The previous designers thought that its not necessary to include the Date added and Date updated columns when they were designing the Database.
This has caused a lot issues when it comes to analyzing the data and auditing.
Please help, this would make my day.
Thanks in Advance :