视图问题,在9i上面没有问题,在10G上执行没有问题,当取
数据的时候出现下面的提示:
ORA-00600:internal error ode,arguments:[qctfrc:csform]:[qctfrc:csform],[60],[60],[0],[0],[1],[2],[452]
CREATE OR REPLACE VIEW V2_4_XM_JBXX_VIEW5 AS
select distinct(X.XMBH_CHAR),G.FWRQ_DATE AS
FWRQ_DATE,G.WJBH_CHAR AS WJBH_CHAR from
VS2_1_1_XMJH_View X,VS2_1_JHWJ_VIEW G where
g.wjbh_char=x.wjbh_char and
g.fwrq_date=(select MIN(H.FWRQ_DATE) from
S2_1_JHWJ_VIEW H WHERE H.WJBH_CHAR IN (SELECT
I.WJBH_CHAR FROM VS2_1_1_XMJH_View I WHERE
I.XMBH_CHAR=X.XMBH_CHAR) )
数据的时候出现下面的提示:
ORA-00600:internal error ode,arguments:[qctfrc:csform]:[qctfrc:csform],[60],[60],[0],[0],[1],[2],[452]
CREATE OR REPLACE VIEW V2_4_XM_JBXX_VIEW5 AS
select distinct(X.XMBH_CHAR),G.FWRQ_DATE AS
FWRQ_DATE,G.WJBH_CHAR AS WJBH_CHAR from
VS2_1_1_XMJH_View X,VS2_1_JHWJ_VIEW G where
g.wjbh_char=x.wjbh_char and
g.fwrq_date=(select MIN(H.FWRQ_DATE) from
S2_1_JHWJ_VIEW H WHERE H.WJBH_CHAR IN (SELECT
I.WJBH_CHAR FROM VS2_1_1_XMJH_View I WHERE
I.XMBH_CHAR=X.XMBH_CHAR) )
http://otn.oracle.com/pls/db10g/portal.portal_demo3?selected=2
他的意思是我的SQL语句有异常而已,不过奇怪的是执行没有问题,当VIEW 数据的时候就出错了,正在排错中……
不过我感觉如果不是玩CLUSTER,10G也不过如此,还和9I有不兼容的问题!
谢谢!