Originally posted by patel_dil
what does
select * from all_synonyms
show?

who is the owner of that table/view? What is the command you are using to create a SYNONYM for that table? does the synonym reference go away from all_synonyms tables once you drop the synonym? This is all I could think. No idea what else is goping wrong here.
I can see the synonym in all_synonyms

I have created the table in a different schema

The command used for creating the synonym is
"CREATE PUBLIC SYNONYM FOR

It goes away from all_synonyms when i dropped the synonym..