system@test816.world>create user rudolf identified by nix 2 /
User created.
system@test816.world>grant connect to rudolf;
Grant succeeded.
system@test816.world>alter user rudolf quota 1M on tools;
User altered.
system@test816.world>connect rudolf/nix Connected. rudolf@test816.world>create table t (id number) storage (initial 2M) tablespace tools; create table t (id number) storage (initial 2M) tablespace tools * ERROR at line 1: ORA-01536: space quota exceeded for tablespace 'TOOLS'
system@test816.world>l 1 create user rudolf 2 identified by nix 3 default tablespace tools -- suggest,repace 'tools' with your own tablespace 4 temporary tablespace temp -- suggest 5 quota 0 on system -- suggest 6* quota unlimited on tools -- suggest, you can have multiline such as this one, also replace 'unlimted', 'tools' as your need system@test816.world>/
User created.
system@test816.world>grant connect,resource to rudolf;
Grant succeeded.
system@test816.world>revoke unlimited tablespace from rudolf -- suggest /
rudolf@test816.world>create table t (id number) storage (initial 2M) tablespace tools; create table t (id number) storage (initial 2M) tablespace tools * ERROR at line 1: ORA-01536: space quota exceeded for tablespace 'TOOLS'