I have been using the Oracle SQL Developer for about a year. I have a scripts I wrote and used two months ago. I have lost them and I had cleared the history on my machine. I would want to have them back but have failed.
I have contacted the data administrative team and they say they don't know if they can retrieve them
I am requesting for assistance on how I can advise them to retrieve the scripts.
I some times use PLSQL but cannot find the history facility
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.