All,
I have a oracle 11g database on machine A, oracle gateway
for MSQL server installed on machine B and MSQL database is on machine C.
Configured the oracle database gateway so that we cane make
connections from oracle database (on A) to MSQL database (on C).
I am able to submit :
select * from [Email Address Removed]
(where msqldblink refers to the oracle database gateway which connects
to MSQL server)
But when I am submit :
select emp_id from [Email Address Removed] I got ORA-00904: "EMP_ID": invalid identifier.

Then I have created that remote table in oracle by this
command :
create table emp as select * from
[Email Address Removed] Then I have again submit :
select emp_id from emp;
(Without dblink)
Again I got ORA-00904: "EMP_ID": invalid identifier.

Can anyone help me understand what is going wrong.

Regards,
Rajesh

Oracle LazyDBA home page