3 Replies Latest reply: Jan 2, 2013 12:57 AM by Osama_Mustafa RSS

    Unable to create index in Oracle

    982433
      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