Oracle GoldenGate GGSCI Commands
Oracle GoldenGate is a powerful tool for real-time data replication. To maintain data integrity and ensure smooth operation, it’s important to follow proper sequences…
CATEGORY
Database
Master SQL, PostgreSQL, MySQL, MongoDB, and trending open-source databases. Learn optimization, design patterns, and best practices for modern data management.
323 articles
Oracle DB Patching: Key Steps
This document outlines the essential steps for Oracle Database patching. It covers pre-checks, patch installation instructions, and post-patching validations. Always refer to the README…
Fast Recovery Area (FRA)
The Fast Recovery Area (FRA) is a centralized storage location in Oracle used to store all essential recovery-related files. It simplifies backup and recovery…
File System Housekeeping with find Command
A tidy filesystem is key to a healthy and efficient server. The find command is a powerful tool for cleaning, compressing, or inspecting files…
Oracle Restore Points
Oracle Restore Points let you mark a point in time to which you can later flashback (rollback) your database quickly. Think of them as…
Transfer Schema Statistics from Source to Target Database
Maintaining consistent optimizer statistics across environments is crucial for stable SQL performance during migrations and refreshes. This guide explains how to export and import…
Schema Object Count
Quick SQL queries to get the count of various objects (like tables, views, packages, etc.) in a specific Oracle schema — useful for monitoring…
Extract DDL for Oracle Objects
This guide shows how to extract the CREATE statements (DDL) for common Oracle objects such as TABLE, VIEW, PROCEDURE, FUNCTION, PACKAGE, TRIGGER, DATABASE LINK,…
Full DB Refresh
Pre Stuff on Source Database This phase is executed on the target database — the environment that is going to be refreshed (typically from…
Oracle Schema Refresh
Schema Refresh copies or synchronizes one or more schemas from a source Oracle database to a target database. It may involve replacing tables and…
Oracle Table Refresh
Table Refresh means updating or replacing one or more tables on a target database from a source database using Data Pump (expdp/impdp), minimizing downtime…
.par File in Oracle Data Pump
A .par file is a plain text file used with Oracle expdp or impdp commands to pass parameters. It keeps your commands short, readable,…