This article explains how to use Oracle Data Pump's ESTIMATE and ESTIMATE_ONLY parameters to assess the size of a 1 TB production database for migration, compares BLOCKS and STATISTICS estimation methods, and details best practices for gathering accurate optimizer statistics with ANALYZE and DBMS_STATS.
This guide provides step‑by‑step Oracle commands for creating and dropping databases, configuring users and tablespaces, performing full and table‑level backups with expdp/impdp, handling version compatibility, and cleaning up residual files and sessions.
This guide provides comprehensive Oracle database commands for creating and deleting databases in 11g/12c, configuring users and tablespaces, and performing full or selective backup and restore operations with Data Pump, along with practical tips for managing sessions, processes, and cleanup.
This article details a real‑world migration from Oracle 11g on IBM AIX to Oracle 19c, focusing on exporting a 2 TB LOB‑heavy table by adjusting undo retention, then using ROWID‑based modulo queries with Data Pump to achieve balanced, error‑free parallel exports.
This guide provides a comprehensive overview of Oracle Data Pump utilities, detailing how to create directories, use expdp and impdp commands for exporting and importing schemas, tables, and full databases, explaining key parameters, interactive mode, and common error resolutions.
This guide answers common Oracle backup questions, covering planning for 50‑TB databases, speed calculations, backup window design, RMAN versus Data Pump, multi‑user and RAC scenarios, catalog usage, performance troubleshooting, and practical SQL queries for monitoring backup status.
The article details a step‑by‑step recovery of an Oracle database where the SYSAUX01.DBF file was corrupted, using DBV detection, attempted repairs, analysis of export/Data Pump failures, and low‑level file parsing to fully restore the ZXFG user's data.
This article explains why exporting a schema with Oracle Data Pump can leave a table's primary‑key sequence behind the actual data, demonstrates the problem with a live test, and provides a step‑by‑step fix by resetting the sequence to the maximum key value.
The article summarizes Digoal's 2017 Gdevops talk, detailing PostgreSQL's advanced features such as block-level BRIN indexes, high‑efficiency range queries, asynchronous messaging, data pumps, real sharding, MADlib machine‑learning integration, FDW data federation, and large‑scale use cases in IoT, finance, and geospatial analytics.
This article presents a comprehensive guide to XTTS, an Oracle table‑space transfer tool that extends TTS with cross‑platform support and incremental backup, comparing it with Data Pump and GoldenGate, detailing step‑by‑step procedures, performance optimizations, real‑world case studies, and a pre‑migration checklist.
This guide details the most effective Oracle Data Pump parameters and related database settings—such as access_method, parallel, network_link, and NLS options—to dramatically improve export and import performance while avoiding common pitfalls.
This article consolidates Oracle ACS architect Zhou Guohong's comprehensive guide on selecting upgrade paths, outlining phase‑by‑phase tasks, highlighting key success factors, and answering common questions about migration tools such as Transportable Tablespaces, Data Pump, and GoldenGate.
