SQLcl Unload Command Extracts Partial Data (Doc ID 2944507.1)

Last updated on MAY 03, 2023

Applies to:

Symptoms

When using the SQLcl unload command and unloading data from a 500GB table it is seen that the total number of records extracted are not matching with the total number of rows in the table.

The following error is found in the unload log file.

#####################################################
DATA TABLE RECURRING_CHARGE_DETAILS_HIST
ORA-03148: OCI_ATTR_ROW_COUNT cannot return a row count exceeding UB4MAXVAL. The actual row count is [4294967300]
File Name: tablename.csv
Number of Rows Exported: 4294967250
** UNLOAD End **
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
#####################################################

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.