Uff This Oracle will Kill Me One Day. I am not able to create table in ORACLE from last so many days...UFF.
I have executed the foll. statements in command Prompt . CREATE TABLE is giving me the ERROR - no privileges on tablespace 'SYSTEM'
Code:
SQL> SHOW USER
USER is "SONIA"
SQL>

SQL> SELECT username,privilege FROM USER_SYS_PRIVS;

USERNAME                       PRIVILEGE
------------------------------ ----------------------------------------
SONIA                          CREATE SESSION
SONIA                          CREATE TABLE

SQL> CREATE TABLE CUSTOMER(CustID Number(5) Primary Key, CustName Varchar(20));
CREATE TABLE CUSTOMER(CustID Number(5) Primary Key, CustName Varchar(20))
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'SYSTEM'