This discussion is archived
3 Replies Latest reply: Jan 1, 2013 10:57 PM by Osama_Mustafa RSS

Unable to create index in Oracle

982433 Newbie
Currently Being Moderated
Hi Everyone

I am new to Oracle and I am unable to create index in oracle database. I am not sure, whether its a authorisation issue or not.

SQL> CREATE INDEX Z05 ON CE1LAOC (MANDT, PALEDGER, BUKRS, PERIO, VRGAR, VKORG, HZDAT);
CREATE INDEX Z05 ON CE1LAOC (MANDT, PALEDGER, BUKRS, PERIO, VRGAR, VKORG, HZDAT)
*
ERROR at line 1:
ORA-00942: table or view does not exist

###Where CE1LAOC is the table name and MANDT.... are columns###
Also I have tried to execute

SQL> CREATE INDEX Z05 ON CE1LAOC (MANDT, PALEDGER, BUKRS, PERIO, VRGAR, VKORG, HZDAT) ONLINE;
CREATE INDEX Z05 ON CE1LAOC (MANDT, PALEDGER, BUKRS, PERIO, VRGAR, VKORG, HZDAT) ONLINE
*
ERROR at line 1:
ORA-00942: table or view does not exist

In SAP, I have created index through SE11, but it says Index doesnot exists in database system Oracle.

Could anyone please help me with this issue.

Regards

Edited by: 979430 on 1/01/2013 22:45

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points