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