Does the user account for your database link have permission to view
the EMP table? Do you have public synonyms for the EMP table (both
local and on the remote DB)? Have your tried select emp_id from
SCHEMA.[Email Address Removed] Price
Oracle Database Administrator
Compusearch Software Systems, Inc.


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

No. I am not able to query to any individual columns. I am only able to
do select * from [Email Address Removed] Price wrote:
> 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
>
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
>



---------------------------------------------------------------------
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