Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Views created from Database link over dg4msql has column type as long

xarg-XrcOct 3 2012 — edited Oct 5 2012

Hi All,

I am reading some views from SQL server using dg4msql to Oracle database 11G r2.

All working well except columns that are typically varchar2 are now of type LONG. This is causing issues given the wide range of restrictions of data type long.

Is there a way that when I create a view in Oracle like:

CREATE or replace view as v1 (
select a1, a2, a3 from msqlserver_table@dblink)

The columns don't come up as long but as varchar2??

Problem is once its in long format, I can't change it to another format in a SELECT statement (like cast it as varchar 2 etc)\

Thanks.

Edited by: xarg-Xrc on Oct 3, 2012 7:26 PM

This post has been answered by Kgronau-Oracle on Oct 5 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 2 2012

Added on Oct 3 2012

#heterogeneous-connectivity

11 comments

2,776 views