My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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 15-Jan-2018 ***

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

To view full details, 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 a vibrant support community of peers and Oracle experts.