My Oracle Support Banner

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 SEPTEMBER 13, 2023

Applies to:

Oracle Loader for Hadoop - Version 1.1.0 and later
Linux x86-64

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.