My Oracle Support Banner

SELECT Statement Using DBMS_SPACE.OBJECT_GROWTH_TREND Fails with ORA-14551 (Doc ID 1094627.1)

Last updated on FEBRUARY 01, 2022

Applies to:

PL/SQL - Version 10.2.0.4 and later
Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.


Symptoms

Executing the following SQL statement:

select * from table(dbms_space.OBJECT_GROWTH_TREND('SCOTT','EMP','TABLE'));

Fails with:

EXCEPTION in chrow processing - code: -1031 msg: ORA-01031: insufficient privileges

When:

serveroutput is set to a value of 'on'

Depending on the operating system and versions being used (or other factors), the error returned could be:

ORA-942 OR
ORA-14551 OR
ORA-1031

For Example:

 





Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


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