CODEWITHSUNDEEP
oracle-databaseprivilegestablespace
Hikmet Benyahia
Hikmet Benyahia

Reputation: 5

no privileges on tablespace 'SYSTEM' ORA-00942

i have this error when trying to create a table graphically:

Creating table "ELEVE" failed. Failed Creating Table ORA-01950: no privileges on tablespace 'SYSTEM' ORA-00942: >table or view does not exist ORA-06510: PL/SQL: unhandled user-defined exception

Upvotes: 0

Views: 1376

Answers (2)

Tuvshinzaya Mendbayar
Tuvshinzaya Mendbayar

Reputation: 16

This happens when your execute user don't have privilege for System tablespace what's the default tablespace of execute user.

Upvotes: 0

Littlefoot
Littlefoot

Reputation: 142713

First of all, you shouldn't do anything in the SYSTEM tablespace. As user you created doesn't have any objects yet, I suggest you drop it and recreate it, but this time by specifying another tablespace. For example:

SQL> connect sys as sysdba
Enter password:
Connected.
SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS

SQL> create user ecole identified by ecole
  2  default tablespace users
  3  temporary tablespace temp
  4  quota unlimited on users;

User created.

SQL> grant create session, create table to ecole;

Grant succeeded.

SQL>

If you, however, insist on doing everything in the SYSTEM tablespace, then alter user and grant quota on the tablespace, e.g.

SQL> alter user ecole quota 100M on system;

User altered.

SQL>

Then create the table.

Upvotes: 1

Related Questions