stressball
Programmer
Hi, I'm using Oracle for NT on my PC at work just to study for Oracle cert, and I get this message when I try to create a table (the default tables of emp, dept etc are not there)
SQL> create table dept
2 (deptno NUMBER(2),
3 dname VARCHAR2(14),
4 loc VARCHAR2(13));
create table dept
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'SYSTEM'
How do I grant my user privileges to the tablespace?
SQL> create table dept
2 (deptno NUMBER(2),
3 dname VARCHAR2(14),
4 loc VARCHAR2(13));
create table dept
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'SYSTEM'
How do I grant my user privileges to the tablespace?