Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Drop a table while you insert data into it !

Drop a table while you insert data into it !

From: vani <VanishriNOVaSPAM_at_hotmail.com.invalid>
Date: 2000/07/20
Message-ID: <200951b2.c9bd76d6@usw-ex0109-069.remarq.com>#1/1

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

Received on Thu Jul 20 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US