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: Adding a column takes ages

Re: Adding a column takes ages

From: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Tue, 17 Aug 2004 14:38:41 +0100
Message-ID: <MPG.1b8c1aaa27bf555f989cc4@news.individual.net>


In article <MPG.1b8c1eb8eb55c873989683_at_iww.cacti.ch.alstom.com>, Marc Eggenberger says...
> In article <MPG.1b8c16d48d2d4d2c989682_at_iww.cacti.ch.alstom.com>,
> marc.eggenberger@_REMOVE_itc.alstom.com says...
>
> > I have a table edb_order_scope (ddl at the bottom of this posting) which
> > has xxxx rows.
>
> Sorry .. should read 144504 rows
>
>

Any triggers on the table? Setting a default value wil leffectively (as I understand it) mean that every row is updated and therefore any triggers will be fired...?

-- 

jeremy
Received on Tue Aug 17 2004 - 08:38:41 CDT

Original text of this message

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