Hi All,
Materialized view is not getting refreshed.But SQL used for generating Materialized view is returning records. Defination of Materialized view is also given below.
BEGIN
DBMS_MVIEW.REFRESH('URIUM.MVIEW_CAD_USERS_P_ALL','C');
END;
Error report -
ORA-12018: following error encountered during code generation for "URIUM"."MVIEW_CAD_USERS_P_ALL"
ORA-00600: internal error code, arguments: [kkzdgdefq], [1], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 85
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2199
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2778
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3058
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3017
ORA-06512: at line 2
12018. 0000 - "following error encountered during code generation for \"%s\".\"%s\""
*Cause: The refresh operations for the indicated materialized view could
not be regenerated due to errors.
*Action: Correct the problem indicated in the following error messages and
repeat the operation.
--Defination of Materialized view
CREATE MATERIALIZED VIEW "URIUM"."MVIEW_CAD_USERS_P_ALL" ("PERSON", "LOGININFO", "GIDINFO", "STATEINFO", "TYP", "IDEAS", "SOLIDEDGE", "NX", "NX_FUTURE", "PROE", "AUTOCAD", "MEDUSA", "CR5000", "CR5000_BOARD_DESIGNER", "TERMINAL_SERVER", "VOLUME", "OSUSER", "LAST_LOGIN", "STATUS", "LICENSELEVEL", "REPORTDATE", "DEFAULTGROUP", "SCD_CN", "SCD_MAIL", "SCD_TCGID", "SCD_SN", "SCD_GN", "SCD_ORGANIZATION", "SCD_ORGA_UNIT", "SCD_FACILITY", "SCD_PHONE", "SCD_FAX", "SCD_DEPARTMENT", "SCD_SPONSOR", "SCD_STREET", "SCD_POSTALCODE", "SCD_CITY", "SCD_GENDER", "SCD_ALTPHONE", "SCD_CELLPHONE", "SCD_COUNTRY", "SCD_BUILDING", "SCD_ROOMNUMBER", "SCD_COSTLOCATION", "SCD_COSTLOCATIONUNIT", "CADCHECK", "IDEAS_HIDDEN", "NX_HIDDEN", "CR5000_HIDDEN", "PROE_HIDDEN", "AUTOCAD_HIDDEN", "NEVERLOCK")
ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
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 "APX_DATA"
BUILD IMMEDIATE
USING INDEX
REFRESH FORCE ON DEMAND
USING DEFAULT LOCAL ROLLBACK SEGMENT
USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE
AS
Thanks and Regards,
Vinay