Hello all,
Database version 12.2.0.1.0
I would like to look at v$sql or dba_hist_sqltext on a certain day to see what command may have edited a very important table. I have a full database dmp file from that day but I'm not sure what or how to import to see these. Do I need to restore the sys schema? or is there no way to do this?
Maybe there is another way altogether but this happened roughly 3 months ago.
Thanks