Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> adding a new column to 19 million records table - how does it really works on 10g?
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