“ORA-01536: space quota exceeded for tablespace ‘USERS”

Loading Java stored procedures in Oracle© Databases with the loadjava utility you may encounter errors with error messages:

“ORA-01536: space quota exceeded for tablespace ‘USERS”

Such error indicates that the schema where the Java classes needed for the stored procedure has surpassed its tablespace quota.

The easiest way to overcome this error and continue with the loadjava class loading is by granting unlimited quota for the destination schema (referred bellow as smithj):

ALTER USER smithj quota unlimited on USERS;