Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Drop a table via synonym
I have 2 schemas
In schema X ,I created a table A.
In schema Y ,I created a synonym to table A.
In Schema Y ,I created a procedure to drop the table A. ORA :00942:table or view does not exist.
Any ideas how should I go with this.
Should I have to use ----drop the table X.A
Pls share your ideas.
Thanks Received on Thu Nov 30 2006 - 17:02:35 CST