ORA-1031 When Running a Procedure After Migrating From Another Environment

(Doc ID 469763.1)

Last updated on OCTOBER 25, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.3 - Release: 9.2 to 11.2
Information in this document applies to any platform.
Checked for relevance on 18-Nov-2011

Symptoms

Running a procedure after importing a schema dump created from a known working source fails with the following errors :

exec SCOTT.CALL_CALC_PRODUCT_PRICE(arg1, arg2);

ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 78
ORA-06512: at "SCOTT.STORE_BASIC_ADULT_PRICE", line 6
ORA-06512: at "SCOTT.SET_BASIC_ADULT_PRICE", line 73
ORA-06512: at "SCOTT.CALC_PRODUCT_PRICE", line 877
ORA-06512: at "SCOTT.CALC_PRODUCT_PRICE_TYPE", line 81
ORA-06512: at "SCOTT.CALL_CALC_PRODUCT_PRICE", line 60
ORA-06512: at line 1


When comparing the privileges of the SCOTT users from the two databases they are exactly the same.

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