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 -> adding a new column to 19 million records table - how does it really works on 10g?

adding a new column to 19 million records table - how does it really works on 10g?

From: Joe <joe1977_at_tlen.pl>
Date: 9 May 2007 19:36:59 -0700
Message-ID: <1178764619.029339.113040@w5g2000hsg.googlegroups.com>


I have a pretty big table with 10 columns, most varchars2 (50). adding a new column to table that already have 19M records takes half a second (through Toad).
question: how does oracle organize data inside table space, and does on should make any database defragmentation after adding additional column to allready so much filled-out table?

thanks for help Received on Wed May 09 2007 - 21:36:59 CDT

Original text of this message

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