How to Compare Data Between Two Databases
Several years ago I made a stored procedure for comparing table row counts between two databases after migration, which can output a very clear and… Read More »How to Compare Data Between Two Databases
Linux – Scripting
How to Take Parallel Jobs to Background in One Line
Suppose you're a SA. In the beginning of the year 2016, you have to execute multiple system analysis reports parallelly for every month last year.… Read More »How to Take Parallel Jobs to Background in One Line
How to Backup RMAN Configuration Daily
Backup RMAN Configuration RMAN can backup almost everything at any state of execution time, includes data, archive logs, even control file and spfile, but I… Read More »How to Backup RMAN Configuration Daily
3 Replace-Equivalent Commands on Linux
Here are several ways to do replacement on Linux:Output the replacing result to the same file by sed with option -i[oracle@test ~]$ sed -i 's/Ed… Read More »3 Replace-Equivalent Commands on Linux