Re: Drop a table via synonym

nicetom786_at_yahoo.com wrote:
> 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

Yes that will work if you grant permissions as needed. But it's not a great idea in most applications to drop tables.

Truncate table perhaps ... that removes all the rows but leaves the table definition and indexes etc still intact.

Why do you think you want to drop tables? Tell us about this part of your application design. Received on Thu Nov 30 2006 - 17:24:22 CST