ora-600 when recreate the MV
- From: Joan Hsieh <joan.hsieh@xxxxxxxxx>
- To: oracle_l <ORACLE-L@xxxxxxxxxxxxx>
- Date: Tue, 20 Apr 2010 15:27:11 -0400
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], [],
[], [], [], [], []
--
http://www.freelists.org/webpage/oracle-l
Other related posts: