BEGIN
LN_SQL:='DELETE FROM '||LN_SOURETABLE|| ' WHERE (STCDT,YMDHM) IN (SELECT STCDT,YMDHM FROM '||LN_TARGETTABLE||' WHERE YMDHM < TO_DATE('''||LN_LASTTIME||''',''YYYY-MM-DD HH24:MI:SS''))';
上面是一条动态 语句;
翻译一下是:delete from tbl_soure@mr where (stcdt,ymdhm) in (select stcdt,ymdhm from tbl_targer@mh where ymdhm <'2005-12-12 8:00:00';
上面语句进行了跨表空间的操作。@mr 和@MH 是跨表空间
EXECUTE IMMEDIATE LN_SQL;
end;
以上是有问题的部分,因为太长,没有全部列出来。
执行完上后错误提示 ORA-02068和ORA-00600 的错误,我左看右看语句都没有问题 ,不知为什么?请大家帮忙看看。谢谢!
file corruption
failed data checks in memory
hardware, memory, or I/O errors
incorrectly restored files
The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle.Action: Report this error to Oracle Support Services after gathering the following information:events that led up to the error
the operations that were attempted that led to the error
the conditions of the operating system and databases at the time of the error
any unusual circumstances that occurred before receiving the ORA-00600 message
contents of any trace files generated by the error
the relevant portions of the Alter files
Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.
文档 ID: 注释:111099.1 类型: PROBLEM
上次修订日期: 02-JAN-2003 状态: PUBLISHED
Problem Description
===================After an upgrade from 7.2.3 to 8.1.5, you receive the following errors
trying to run a stored procedure:ORA-02068: following severe error from TOVIEW
ORA-00600: internal error
SQL statement:
ORA-02068: following severeerror from TOVIEW
ORA-00600: internal error code, arguments: [12443], [], [],[], [], [], [], []
ORA-06512: at "ADS_DBA.REFORECAST", line 83
ORA-06512: atline 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 781
ORA-06512: at"SYS.DBMS_SQL", line 316
ORA-06512: at "ADS_DBA.MSG_EXEC_PROCEDURE", line13
ORA-06512: at line 1
Solution Description
====================This is most likely due to Bug 1022399 which is fixed in releases 8.1.6.3 and
8.1.7. A symptom of this bug can be an ORA-600 [12443] error on a remote
collocated join operation.
Explanation
===========The bug indicates that there is a problem when the tables are remote or
co-located because the SQL is mapped differently. There is a ctx pointer that
generates the position of mapping the bind variables. However, with colocated
remote joins the position map is not needed.
你这个语句是跨服务器操作,碰到了数据库的bug升级到8.1.7吧