I'm new to Oracle so please bear with me.
After installing Oracle XE 11.2, I created user
SALES and granted
create session and
create table to the user.
Once I logged in with
SALES I tried to create a table and I get the error
ORA-01950: no privileges on tablespace 'SYSTEM'.
A related question in DBA StackExchange says that I should
alter database default tablespace users;. and then assign a higher quota to user, like so:
alter user SALES quota 50m on system;
I've already changed the default tablespace to
My question is: shouldn't I
alter user SALES quota 50m on users; instead of tablespace