view for 2 db
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
Its ok if i remove the rowid...but the programmer needs it.
use to_char on the rowid then the datatype will be the same
Thanks...I tried it but i got different error
ora-932 inconsistent datatypes: expected NUMBER got ROWID
Last edited by yxez; 08-30-2005 at 06:41 AM.
change to_char to rowidtochar
thanks again davey,,,i try it tomorrow
Last edited by yxez; 08-31-2005 at 05:22 AM.
Yesss it worked you r a genius davey thanks a lot
Click Here to Expand Forum to Full Width