Insert: ORA-01950 no privileges on tablesapce 'USERS'

ellison · Post by **ellison** » Mon Apr 27, 2015 10:14 am

I trying to perform a simple load to an Oracle table using Oracle Connector. I've like to use mode truncate, but have also tried just insert. I'm getting error ORA-01950, no privileges on tablespace 'USERS'. The table is not in the USERS tablespace, and I apparently do have a quota defined for USERS. Why am I getting this error on USERS? Is it trying to build some work table?

chulett · Post by **chulett** » Mon Apr 27, 2015 10:20 am

The table is setup incorrectly, talk to your DBA and have them correct the problem.

ellison · Post by **ellison** » Wed Apr 29, 2015 8:57 am

Althought the table was created using the correct schema and tablespace, the indexes were not. The indexes needed to be recreated using the correct tablespace.