Diagnosing ORA-06502 "no data found" Errors When Accessing OceanBase LOBs via JDBC

This article explains why JDBC access to OceanBase (Oracle mode) LOB columns can trigger an ORA-06502 "no data found" error, analyzes the driver’s readFromServer implementation, and shows how disabling the useLobLocatorV2 option eliminates the exception.

DBMS_LOBJDBCLOB

0 likes · 8 min read

Diagnosing ORA-06502 "no data found" Errors When Accessing OceanBase LOBs via JDBC

dbaplus Community

Jan 24, 2021 · Databases

Why Oracle Converts Extended VARCHAR2 to LOB and How It Affects Performance

This article explains how Oracle automatically stores extended VARCHAR2 columns as LOBs, shows the storage differences for values below and above 4000 bytes, provides step‑by‑step SQL demonstrations, and outlines the performance implications and tuning considerations.

Extended Data TypeLOBOracle

0 likes · 10 min read

Why Oracle Converts Extended VARCHAR2 to LOB and How It Affects Performance

dbaplus Community

Jul 23, 2020 · Databases

How to Export a 2TB Oracle LOB Table Using Rowid Partitioning

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.

Data PumpExportLOB

0 likes · 8 min read

How to Export a 2TB Oracle LOB Table Using Rowid Partitioning