Don’t be left behind. GoldenGate Migration Utility was created to help you migrate from Classic to Microservices architecture without many… READ MORE
We were pleased to announce the availability of Oracle GoldenGate Free 21c, the same robust Oracle GoldenGate that enterprises worldwide… READ MORE
Most of the time, when GoldenGate extract runs without a hitch, and the GoldenGate monitor displays no anomalies or slowness,… READ MORE
Automatic Conflict Detection and Resolution is critical to any active/active and multi-master GoldenGate implementation. The following are the most important… READ MORE
If you need to set your TNSNAMES.ora file in the new GoldenGate 21c Microservices, how do you find the location?… READ MORE
This Thanksgiving weekend, I wanted to create an easy and repeatable process to instantiate a GoldenGate Docker container for different… READ MORE
Let’s add and start an Extract with REST API, note that I am not starting at creation: — Add Extractcurl… READ MORE
If for some reason the online redo log were lost or when cloning the copy of shutdown database you don’t… READ MORE
In 11g Oracle supports password to be case sensitive. But the password can be case insensitive depending on value of… READ MORE
For SQLServer: — Clears all the procedure cache (works on SQLServer 2005 and SQLServer 2008) DBCC FREEPROCCACHE http://msdn.microsoft.com/en-us/library/ms174283%28v=SQL.90%29.aspx — On… READ MORE
Using the following SQL one can find tables that contain a column name. In SQLServer SELECT table_name, column_name FROM INFORMATION_SCHEMA.COLUMNS… READ MORE
In Oracle Using MINUS and UNION ALL one can compare 2 tables to find differences in data in the tables.… READ MORE
|
Table structure in Oracle SQL> desc scott.oracletable; Name Null? Type —————————————– ——– ———- TRANSDATE NOT NULL DATE SEQUENCE_NO NOT NULL… READ MORE
“Control what I can control”
~ Alex Lima