Pages

▼
Wednesday, April 28, 2021

LEFT JOIN vs INNER JOIN vs WHERE

›
===================== General ===================== LEFT JOIN vs INNER JOIN vs Regular WHERE   ===================== Example ===============...
Monday, April 19, 2021

Error ORA-01000 Too many open cursors is coming, and it is not clear why.

›
========== General ========== Error ORA-01000 Too many open cursors is coming, and it is not clear why. Code below is logging number of curs...
Tuesday, April 13, 2021

A Function that return a table

›
===================== A Function that return a table ===================== --CREATE OR REPLACE TYPE myTableType   AS TABLE OF myObjectFormat...
Monday, April 12, 2021

cmd bat script to delete files in a directory olden than X days

›
@echo OFF REM cd D:\SfiGen\ArchiveDir SET DEL_DIR=D:\SfiGen\ArchiveDir SET WORK_DIR= D:\SfiGen\scripts SET KEEP_DAYS=30 ECHO start delete fi...
Thursday, April 8, 2021

Golden Gate Extracts are in ABENDED state. Error: Missing Log File WAITING FOR REDO: FILE NA

›
Golden Gate Extracts are in ABENDED state with error: ERROR   OGG-02870  Missing Log File WAITING FOR REDO: FILE NA, THREAD 1, SEQUENCE 0, ...
Wednesday, March 31, 2021

Clean SYSAUX Tablespace, purge data from WRI$_ADV_OBJECTS

›
============ Issue  ============ Tablespace SYSAUX nearly 100% full because table WRI$_ADV_OBJECTS and related indexes are very big This i...
Thursday, February 18, 2021

GG Restart from crontab

›
========================= General =========================  Restart GG processes from crontab ========================= Code ==============...