Originally posted by bang_dba
I Dont had any user by name BALKE....
You get "ORA-00942: table or view does not exist"
when u create a PUBLIC synonym
create public synonym xxx for th.ddf
SELECT * FROM XXX
ORA-00942: table or view does not exist
Yes indeed on 8.x it throws this misleading error. But 9.x no probs, the error is relevent.
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"