begin
DBMS_SNAPSHOT.REFRESH(
LIST => 'KIOS.MV_MUSTERILISTESI_YENI'
,METHOD => '?'
,PUSH_DEFERRED_RPC => TRUE
,REFRESH_AFTER_ERRORS => FALSE
,PURGE_OPTION => 1
,PARALLELISM => 0
,ATOMIC_REFRESH => TRUE
,NESTED => FALSE);
end;
ORA-12018: "KIOS"."MV_MUSTERILISTESI_YENI"için kod üretimi sırasında aşağıdaki hata ile karşılaşıldı
ORA-00913: çok fazla değer
ORA-06512: konum "SYS.DBMS_SNAPSHOT", satır 2809
ORA-06512: konum "SYS.DBMS_SNAPSHOT", satır 3025
ORA-06512: konum "SYS.DBMS_SNAPSHOT", satır 2994
ORA-06512: konum satır 2
Also I see that, the materialized view is invalid.
select count(*) from dba_objects where status = 'INVALID' and object_name = 'MV_MUSTERILISTESI_YENI';
>> 1
I read the following thread, but I can't find the solution. Because the materialized view that I run DBMS_SNAPSHOT.REFRESH package is the same user who owner the materialized view. What should I do?
QUESTION: Permissions issue doing fast refresh
Is there any way to show log table of materialized view?
Thanks