You may get “ORA-01950: no privileges on tablespace users” while creating tables, indexes, executing some scripts like procedures and triggers.
ORA-01950: no privileges on tablespace 'ORAHOW_TDE'
ORA-06512: at "ORAHOW.UTT_PR_CONFIGURATION", line 108
ORA-04088: error during execution of trigger ' ORAHOW.UTT_PR_CONFIGURATION'
ORA-06512: at line 523
How to resolve ORA-01950: no privileges on tablespace
STEP 1: Connect to sysdba.
-------------------------
sqlplus / as sysdba
STEP 2: Check tablespace quota.
-------------------------------
select username,tablespace_name,bytes/1024/1024/1024,MAX_BYTES/1024/1024/1024 from dba_ts_quotas where username='ORAHOW';
STEP 3: Grant tablespace quota to the user.
-------------------------------------------
SQL> alter user <username> quota unlimited on <tablespace_name>;
SQL> GRANT UNLIMITED TABLESPACE TO <username>;