2 years ago
#63960
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