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

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version 10.2.0.4 and later
Oracle Server - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Nov-2012***


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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms