Home › ORA-01950: no privileges on tablespace 'SYSTEM'

ORA-01950: no privileges on tablespace 'SYSTEM' 

Dr. Xi
Joined:
04/09/2007
Posts:
565

February 06, 2010 00:25:00    Last update: February 06, 2010 00:26:50
Solution: 
grant unlimited tablespace to <user>

or 
alter user <user_name> quota 250m on <tablespace_name>


Example: 
SQL> create table customer (
  2  id number(9),
  3  name varchar2(40));
create table customer (
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'SYSTEM'


SQL> quit
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

C:\>sqlplus system@xe

SQL*Plus: Release 10.1.0.5.0 - Production on Fri Feb 5 18:19:08 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> grant unlimited tablespace to jpa;

Grant succeeded.

SQL> quit
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

C:\>sqlplus jpa@xe

SQL*Plus: Release 10.1.0.5.0 - Production on Fri Feb 5 18:20:42 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> create table customer (
  2  id number(9),
  3  name varchar2(40));

Table created.

SQL>
[ Comment  | Tags ]
 
Easy email testing with http://www.ximailstop.com