SQLcl has many new little tricks that can help us on a daily basis, below is an example how we … More
Category: SQL – DDL
Extract Index DDL from expdp
I recently wanted to drop the indexes during a load and recreate after. There are several ways to do that, … More
Purge DDL tables in GoldenGate for multiple instances
When setting up a DDL replication in Integrated Capture there are couple tables that gets populated on a regular basis, … More
How to add a new not null column in a table without providing a default value?
The following shows how to add in a table a new column that is NOT NULL when a table already … More
