Forum Stats

  • 3,767,984 Users
  • 2,252,736 Discussions
  • 7,874,399 Comments

Discussions

ORA-03148: OCI_ATTR_ROW_COUNT cannot return a row count exceeding UB4MAXVAL.

User_6RAXV
User_6RAXV Member Posts: 1 Red Ribbon

Hello!

I’m using Oracle SQLDeveloper Command-Line (SQLcl) version: 21.3.2.0 build: 21.3.2.287.1503 for Oracle EE 12.2.0.1.211019. I’ve tried to split big partition and got:

ORA-03148: OCI_ATTR_ROW_COUNT cannot return a row count exceeding UB4MAXVAL. The actual row count is [9868887344]03148. 00000 – “OCI_ATTR_ROW_COUNT cannot return a row count exceeding UB4MAXVAL. The actual row count is [%s]”

*Cause: The row count was larger than UB4MAXVAL. OCI clients using

OCI_ATTR_ROW_COUNT cannot see row counts larger than UB4MAXVAL.

*Action: Upgrade Oracle client to version 12 client libraries or higher and

use OCI_ATTR_UB8_ROW_COUNT instead.

Does anyone know is this error caused by database or by sqlcl? Oracle support haven’t provided me answer on this question yet.

Regards, Dmytro