java.sql.SQLException: ORA-00942: table or view doesn’t exist

When loading one of our addon products for the Oracle© Database, with the loadjava tool, you may encounter the error:

java.sql.SQLException: ORA-00942: table or view doesn’t exist

The reason for the above error is that the schema (database login account) under which the loadjava must store the JAR files of our addon doesn’t have sufficient storage quota.

In order to enable to perform the JAR file loading you have to execute under a database login account with SYSDBA role:

ALTER USER smithj quota unlimited ON USERS;

And then you can perform again the loadjava step from the addon Setup.

Note: Replace above ‘smithj‘ with the database account/schema name/ under which our addon product will be stored.