Are you able to perform a select on any other column in the emp table?


Stephen Price
Oracle Database Administrator
Compusearch Software Systems, Inc.

-----Original Message-----
From: Rajesh kalaria
[mailto:oracledba-ezmlmshield-x55062893.[Email address protected]
Sent: Friday, May 30, 2008 8:31 AM
To: LazyDBA Discussion
Subject: ORA-00904: "EMP_ID": invalid identifier

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


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page