Re: Drop a table while you insert data into it !

Perhaps I need some clarification:
Why would you want to simultaneously insert/update a table while dropping it?

where would the data go...

vani <VanishriNOVaSPAM_at_hotmail.com.invalid> wrote:

>Hi!
> I want to Drop a table in Oracle 7.3 while
> inserting or updating data to it from a
> different program.
>
> Can this be done by the following steps:
> 1. lock table xyz in exclusive mode nowait;
> 2. drop table xyz;
>
> Any other ideas ?
>
> Thanks for your help in advance.
> Vani
>
>
>
>
>* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful
Received on Thu Jul 20 2000 - 00:00:00 CDT