No privileges on tablespace 'SYSTEM'

[bprasanth]

I create my own database with user_name:super and password:super. When I am try to create a table with this user name and password then it show the below error:
ERROR at line 1:
ORA-01950: no privileges on tablespace 'SYSTEM'
What can I? Whether I have to change the tablespace of 'SYSTEM' or not?If any one know the reson for this please send me the feedback at bprasanth_nair@ yahoo.co.in

[Niheel]

{ posted in wrong forum, moved to oracle forum }

[Mondo Tofu]

when creating a user, always specify the tablespace where the schema objects should be stored.

For example,

CREATE USER super IDENTIFIED BY super
DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;

GRANT CONNECT, RESOURCE, UNLIMITED TABLESPACE to super;


When you connect to your user name (i.e. SUPER/SUPER), then you will have access to the USER tablespace and all your objects will reside there unless you specify otherwise in the TABLESPACE clause of any DDL SQL statements you execute.

Users' objects belong in separate tablespaces never in the SYSTEM tablespace.