view for 2 db

[yxez]

Hi,

I have two tables EMP residing on 2 diff servers, One is in
Oracle 9i and one is on 10g. Our apps developer wants a union
view for the two tables including their rowids.
When I created the view i got this error:

Create view emp_all as
select rowid,empid,ename from emp@ora9i union all
select rowid,empid,ename from emp@ora10g;
*
ora-1790 - expression must have tjhe same datatype as
corresponding expression
Its ok if i remove the rowid...but the programmer needs it.

Pls help....

Thanks

[davey23uk]

use to_char on the rowid then the datatype will be the same

[yxez]

Thanks...I tried it but i got different error

to_char(rowid) rowid1,ename....
ora-932 inconsistent datatypes: expected NUMBER got ROWID


Pls help

[davey23uk]

change to_char to rowidtochar

[yxez]

thanks again davey,,,i try it tomorrow

[yxez]

Yesss it worked you r a genius davey thanks a lot