This content has been marked as final. Show 3 replies
ORA-00942: table or view does not existcheck who is owner of CE1LAOC table. and try to create index after logging with correct schema.
ORA-00942: table or view does not existAre you table is exists
to check table if exists
What is your current Oracle user ?
Try to identify the table owner:
And add <table owner> as prefix to table name:
select owner from dba_tables where table_name='CE1LAOC';
CREATE INDEX Z05 ON <table_owner>.CE1LAOC (MANDT, PALEDGER, BUKRS, PERIO, VRGAR, VKORG, HZDAT);