We are making Oracle Insight Application based on Oracle 11gR2 DB.
We have two DEV environments.
On Oct 17, we had trouble in one DEV environment.
From dba_common_audit_trail , we found some user did drop public synonym statement and we doubt it as cause of the problem.
I would like to collect synonym information of the two DEV environment.
1
How could I do that ?
2
And we are thinking of using Logminer to investigate the cause of problem.
Logminer is usable to investigate the cause of problem if we have the REDO log of Oct 17 ?