I would like to compose a script to list backup statuses, but I am having difficulty filtering out all but the last backup from a RMAN> list backup; command. Optimally, i would like just the last backup's date/time and it's success/failure status.
My databases are all running on Solaris 5, but are a mixture of 126.96.36.199, 10.2.0.4, and 188.8.131.52
Truncate is a DDL Command where as Delete is a DML Command.
Both will delete data from table, but what is the difference between these below statements
truncate table <table_name> ??
delete from <table_name> ??
The first command cannot be …
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.