DBLINK — 3 Technical Articles

Jul 15, 2021 · Databases

Recovering an Oracle Table After a Week-Long Data Mishap with RMAN and DBLINK

This guide walks through restoring a mistakenly updated Oracle 11.2.0.1 table to a specific point in time using RMAN tablespace recovery on a new host, handling Windows-specific issues, and finally retrieving the data via a database link, with full scripts and step‑by‑step instructions.

DBLINKDatabase RecoveryOracle

0 likes · 14 min read

Recovering an Oracle Table After a Week-Long Data Mishap with RMAN and DBLINK

ITPUB

Nov 24, 2018 · Databases

Why Did My Oracle SQL Run in Parallel? Uncovering Hidden Parallelism and Fixing It

This article walks through diagnosing unexpected Oracle parallel execution, resolving DBLINK‑induced plan anomalies after a database upgrade, and fixing ORA‑00604 errors caused by missing domain indexes, providing step‑by‑step queries, parameter checks, and corrective ALTER statements to restore normal performance.

DBLINKDomain IndexOracle

0 likes · 12 min read

Why Did My Oracle SQL Run in Parallel? Uncovering Hidden Parallelism and Fixing It

ITPUB

Jun 22, 2017 · Databases

Boost Oracle Distributed Queries with the DRIVING_SITE Hint

This article explains how the DRIVING_SITE hint can reduce network traffic in Oracle distributed queries by pushing small tables to the remote site, demonstrates setup steps, compares execution times with and without the hint, and provides concrete PL/SQL scripts for performance testing.

DBLINKDistributed QueryOracle

0 likes · 9 min read

Boost Oracle Distributed Queries with the DRIVING_SITE Hint