by Javier Morales Carreras | Mar 10, 2023 | SQL
For the result of an SQL query to be ordered, the only valid clause is ORDER BY. Oracle only guarantees the ordered return of rows when ORDER BY is set as the sort criteria. I have repeated these two phrases like a mantra thousands of times. Any other way to get the...
by Javier Morales Carreras | Mar 7, 2023 | GoldenGate
When you first start a replication deployment with Oracle GoldenGate, it’s easy that you miss one or several steps that lead you so some errors. Sometimes, the error message in GoldenGate is not so descriptive, or the implications within are not so clear, so...
by Javier Morales Carreras | Mar 2, 2023 | GitHub projects
As every year, it’s time to clean up the databases Marie Kondo style. Database administrators have to historicize, compress or delete old partitions that are no longer needed. Obviously, partitioned tables (and their local indexes) are the best place to...
by Javier Morales Carreras | Jan 22, 2023 | GitHub projects
Let’s talk about physical backups and how to get a report based on your own “safety criteria” about the successfull backups needed to ensure a safe recovery scenario. In many places, they get reports when backups end successfully, or sometimes only...
by Javier Morales Carreras | Dec 26, 2022 | GitHub projects
One of the “Mentor Dojo” students got this request from his manager. They wanted to estimate the growth of a all the objects of a certain tablespace or schema in one month. My first answer was “well, let’s assume the last month growth”,...