Oracle by dblink link DB2 database, read data automatically when the character type field length 6 times to expand, such as A varchar2 (20) to oracle side becomes A varchar2 (120), so for more than 667 characters in DB2 field in oracle end more than 4000, according to the limit and can't

Problem oracle environment: 12 c based on 64 - bit Linux

Another 10 g based on Windows, there is no this problem, but there is another SQLSTATE 01517 questions, don't do consulting focus here,

Excuse me each big coffee. How to adjustment in oracle (DB2 end not let operation), can make according to the original length display field

Troubled for a long time, if can help, thanks a lot!

CodePudding user response:

Solve the