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 -> Re: dropping a large number of tables?

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

Original text of this message

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