Re: Drop a table via synonym

Thanks for yor reply.
[Quoted] [Quoted] As per design,The procedure should drop the table and create the table each time when run.

drop table A
[Quoted] create table A as select * from table B where 1=2;

So a synonym will not help in this case...... Pls advise.

hpuxrac wrote:
> 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 Fri Dec 01 2006 - 00:32:18 CET