I have Oracle9.2.x Enterprise installed on my computer. I have created the database and have created a user with certain admin privileges. When I try to create a table in sqlplus, I get the following error:
ORA-01950: no privileges on tablespace 'USERS'
How can I grant privileges to the USERS tablespace OR how can I create a new tablespace and grant the privileges necessary to allow my user that I created to create tables?