1- One of the obsolete integrated extract was causing Rman not to delete expired archive logs. orcl:/u02/DBA/scripts ->./delete_arch.sh The Oracle… READ MORE
SQLcl has many new little tricks that can help us on a daily basis, below is an example how we… READ MORE
in 12c Oracle has introduced and new field in the v$event_name view called DISPLAY_NAME. After review the contents on more… READ MORE
|
Download Instant Client for macOS http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html#ic_osx_inst This file contains hidden or bidirectional Unicode text that may be interpreted or compiled… READ MORE
Today I had it with Firefox on Linux and wanted to install Chrome, here are the steps I followed and… READ MORE
Here is a simple validation mapping to verify if the value in the trail file is numeric. I had to… READ MORE
The objective of this document is to demonstrate how to install and configure the new Oracle 12.3 GoldenGate Microservices Architecture.… READ MORE
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To… READ MORE
Replicat abending with database error 1403() during the initial startup during a compressed update. This error can be seen very… READ MORE
A quick emergency FRA clean up when archived logs are full. This file contains hidden or bidirectional Unicode text… READ MORE
I recently wanted to drop the indexes during a load and recreate after. There are several ways to do that,… READ MORE
Today I ran into a scenario where I need to check if a table had an UNIQUE index. Instead of writing… READ MORE
The Oracle Lifetime Support Policy brochure for tech products has… READ MORE
When setting up a DDL replication in Integrated Capture there are couple tables that gets populated on a regular basis,… READ MORE
“Control what I can control”
~ Alex Lima