129

I'm getting this error:

ORA-01950: no privileges on tablespace 'USERS'

I have a default tablespace and I'm able to create tables, however, they do not show at the objects tab in Toad. I cannot insert anything into tables I create.

Barbaros Özhan
  • 59,113
  • 10
  • 31
  • 55
sam
  • 2,493
  • 6
  • 38
  • 73
  • 3
    I altered *my* user to no effect. I then altered the *owner* user and was able to add rows. – Steve11235 Mar 25 '14 at 14:40
  • 4
    @Steve11235 If you think about it, that's the only logical way. The object belongs to the owner, therefore the data 'belongs' to the owner, and therefore the quota of the owner is taken into account (otherwise, Oracle would need to track ownership for every single row in the database - highly impractical and mostly useless). – Frank Schmitt May 16 '14 at 06:37
  • 1
    This worked for me : GRANT UNLIMITED TABLESPACE TO ; – Greg Jul 18 '22 at 13:19

1 Answers1

257

You cannot insert data because you have a quota of 0 on the tablespace. To fix this, run 

ALTER USER <user> quota unlimited on <tablespace name>;

or

ALTER USER <user> quota 100M on <tablespace name>;

as a DBA user (depending on how much space you need / want to grant).

Frank Schmitt
  • 30,195
  • 12
  • 73
  • 107