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