2 years ago

#63960

test-img

coeurdange57

Oracle error "M_ROW$$": invalid identifier when restoring a materialized view

I tried to restore a materialized view in my DB by using the sql script. The view is correctly created but the script has failed when creating the index. There the sql issue:

  CREATE UNIQUE INDEX "APP"."I_SNAP$_APP_HIST_LIB_OR1" ON "APP"."APP_HIST_LIB_ORGANES_MV" ("M_ROW$$") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "APP_DATA" ;

The issue:

ORA-00904: "M_ROW$$": invalid identifier

I don't know what is "M_ROW$$".

After looking on forums, the reason should be that this identifier is not present in the table but present in the mview log. But I don't have access to mview log.

Could you please confirm me that or tell me how to solve this issue ?

Thanks in advance for your help

database

oracle

materialized-views

0 Answers

Your Answer

Accepted video resources