重庆思庄Oracle、Redhat认证学习论坛

标题: DBLINK USING SEQUENCE GENERATES INVALID DESCRIBE SELECT /*+ FULL(P)+*/ [打印本页]

作者: 刘泽宇 时间: 2024-10-13 12:19
标题: DBLINK USING SEQUENCE GENERATES INVALID DESCRIBE SELECT /*+ FULL(P)+*/
现象：
DBLINK USING SEQUENCE GENERATES INVALID DESCRIBE SELECT /*+ FULL(P)+*/

Problem Description
---------------------------------------------------
WARNING: too many parse errors, count=1240 SQL hash=0x91806051
PARSE ERROR: ospid=51875, error=2201 for statement:

SELECT /*+ FULL(P) +*/ * FROM "OWNER."SEQUENCE" P

原因：
Bug 28865544

处理方法：
Apply the below Patch in both source and target RDBMS versions.

Patch 28865544: INSERT OVER DBLINK USING SEQUENCE GENERATES INVALID DESCRIBE SELECT /*+ FULL(P) +*/

If the patch is not available in MOS, then request a back port for your version/platform via a Service Request with Oracle Support

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)