Re: dropping a large number of tables?

From: Gerard M. Averill <gaverill_at_chsra.wisc.edu>
Date: 1998/10/23
Message-ID: <70q8t2$c92$2@news.doit.wisc.edu>#1/1

In article <70o0m5$fmr$1_at_nnrp1.dejanews.com>, attwoody_at_my-dejanews.com wrote:

<snip>

>This script generates the DROP TABLE for each of the 1900+ tables. Your

<snip>

You might try also generating a 'TRUNCATE TABLE ' || Table_Name || ';' statement before the DROP TABLE statement. TRUNCATE will remove all rows without generating redo log information, while according to the documentation, DELETE removes all rows "as if they had been deleted" (question: is this the same as "if they had been DELETEd", i.e. will delete triggers be fired?)

---

Gerard M. Averill, Associate Researcher
CHSRA, University of Wisconsin - Madison GAverill_at_chsra.wisc.edu Received on Fri Oct 23 1998 - 00:00:00 CDT