ORA-01031 and ORA-00942 with LOADJAVA (Doc ID 1561769.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

*** Checked for relevance on 04-Jul-2017 ***

Symptoms

User TEST1 has the following permissions:

CREATE USER TEST1 IDENTIFIED BY TEST1;
GRANT CONNECT, RESOURCE, CREATE PUBLIC SYNONYM TO TEST1;
GRANT CREATE ANY PROCEDURE TO TEST1;
GRANT CREATE ANY INDEX TO TEST1;

User TEST2 has the following permissions:

CREATE USER TEST2 IDENTIFIED BY TEST2;
GRANT RESOURCE TO TEST2;

 

Loadjava fails with the following errors:

loadjava -user TEST1/TEST1 -verbose -resolve -schema TEST2 activation.jar

Error while creating "TEST2".CREATE$JAVA$LOB$TABLE
    ORA-01031: insufficient privileges

Error while getLoadLOB TEST2
    ORA-00942: table or view does not exist



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