Forum Stats

  • 3,824,906 Users
  • 2,260,438 Discussions
  • 7,896,343 Comments

Discussions

When i am going to create table i am geting this type of error :ERROR at line 1: ORA-01031: insuff

User_KAYOB
User_KAYOB Member Posts: 5 Green Ribbon

SQL> CREATE TABLE EMP

 2     (EMPNO NUMBER(4) NOT NULL,

 3     ENAME VARCHAR2(10),

 4     JOB VARCHAR2(9),

 5     MGR NUMBER(4),

 6     HIREDATE DATE,

 7     SAL NUMBER(7, 2),

 8     COMM NUMBER(7, 2),

 9     DEPTNO NUMBER(2));

CREATE TABLE EMP

*

ERROR at line 1:

ORA-01031: insufficient privileges

Answers