java.sql.SQLException: ORA-00942 and ORA-02002

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.

Resolution:

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.

ORA-02002: error while writing to audit trail

The auditing facility is unable to write to the AUDIT_TRAIL table. If this error occurs, SQL statements that are currently being audited may also fail.

Resolution: Ensure that the SYSTEM tablespace has enough disk space.