ORA-01950: no privileges on tablespace

On Oracle please set table space quota, for the example this User schema grant table to unlimited.

This Code :

GRANT UNLIMITED TABLESPACE TO <userschema>

For the limit quota on tablespace name, example :

ALTER USER <userschema> QUOTA 100M ON <tablespace name>

www.diarycoding.com

Leave a Comment.