This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,299 Users
  • 2,269,776 Discussions
  • 7,916,824 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