Getting Exception running Oracle Loader for Hadoop Job - 'java.sql.BatchUpdateException: ORA-01950: no privileges on tablespace 'USERS' (Doc ID 1483539.1)

Last updated on APRIL 04, 2017

Applies to:

Oracle Loader for Hadoop - Version 1.1.0 and later
Linux x86-64
***Checked for relevance on 02-Nov-2015***

Symptoms

Running an Oracle Loader for Hadoop job and the job runs successfully however no rows are being inserted into the Oracle Database table.

Upon further investigation in the Oracle Loader for Hadoop log file called oraloader-00000-jdbc.log the following errors are found:

Oracle Loader for Hadoop Release 1.1.0.0.1 - Production

Copyright (c) 2011, Oracle and/or its affiliates. All rights reserved.


Insertion Errors
================

Partition: SYS_P121
java.sql.BatchUpdateException: ORA-01950: no privileges on tablespace 'USERS'

Failure between rows 0 and 7. Insert status for 7 rows is unknown.

Partition: SYS_P122
java.sql.BatchUpdateException: ORA-01950: no privileges on tablespace 'USERS'

Failure between rows 0 and 6. Insert status for 6 rows is unknown.

Partition: SYS_P123
java.sql.BatchUpdateException: ORA-01950: no privileges on tablespace 'USERS'

Failure between rows 0 and 7. Insert status for 7 rows is unknown.

 

 

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