Quote Originally Posted by sonia_1985 View Post
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'
You don't want to create user objects like a tale in SYSTEM tablespace.

Create a tablespace for your stuff, grant privs on it to SONIA, set that tablespace as the default tablespace for user SONIA then create your table :-)