Oracle Hata Kodları

ORA-01950: No Privileges On Tablespace ‘USR_ABUZER’

ERROR :

While creating a table got ORA-01950: no privileges on tablespace ‘USERS’.

SQL> create table ABUZER.SAMPLE_TBL as select * from user_objects;
create table SAMPLE_TBL as select * from user_objects
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'USERS'

SOLUTION :

This error comes, when the user the user doesn’t have tablespace quota.

  1. Check the tablespace quota.
select username,tablespace_name,bytes/1024/1024/1024,MAX_BYTES/1024/1024/1024 from dba_ts_quotas where username='ABUZER';
 
no rows selected.
 

Grant some QUOTA to the user.

SQL> alter user ABUZER quota UNLIMITED on USERS;
 
User altered.
 
SQL> select username,tablespace_name,bytes/1024/1024/1024,MAX_BYTES/1024/1024/1024 from dba_ts_quotas where username='ABUZER';
 
 
USERNAME         TABLESPACE_NAME                BYTES/1024/1024/1024 MAX_BYTES/1024/1024/1024
---------------- ------------------------------ -------------------- ------------------------
ABUZER         USERS                                             0                        UNLIMITED

With QUOTA

SQL> alter user ABUZER quota 1G on USERS;
 
User altered.
 
SQL> select username,tablespace_name,bytes/1024/1024/1024,MAX_BYTES/1024/1024/1024 from dba_ts_quotas where username='ABUZER';
 
 
USERNAME         TABLESPACE_NAME                BYTES/1024/1024/1024 MAX_BYTES/1024/1024/1024
---------------- ------------------------------ -------------------- ------------------------
ABUZER         USERS                                             0                        1G
Tags

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114

Bugra Parlayan

I use this blog in my spare time to jot down thoughts and share my professional experiences. It’s my personal space to unwind and reflect. Feel free to share or reuse anything you find helpful here — just a small thank you is more than enough :) You can reach me at: bugra[@]bugraparlayan.com.tr

Related Articles

Leave a Reply


Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114
Back to top button
Close