Hi Listers, HR has upgraded from 10.2.0.4 to 11.2.0.1 FM is 10.2.0.4. After HR upgraded, I am testing the MV from both applications.I have more than 10 MVs from HR to FM. All worked except 2 views not working. Do you know how to resolve the error?
Thanks, Joan create materialized view PS_HR_TFTH_NM_LBR_VW refresh complete start with sysdate next sysdate + 1 with rowid as SELECT EMPLID , EFFDT , NAME FROM PS_NAMES@hrdev9 WHERE NAME_TYPE = 'PRI' / WHERE NAME_TYPE = 'PRI' * ERROR at line 11:ORA-00600: internal error code, arguments: [kghfrf1], [0x000000000], [], [], [], [], [], []
-- //www.freelists.org/webpage/oracle-l