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 and later
Oracle Database - Enterprise Edition - Version 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.


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


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

For Example:



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

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