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.




Reply With Quote