How to resize table initial size?

[marist89]

Originally posted by jovery

Why do you want to move the data to a single extent?

[ayeleta]

Isn't 1 extent better for performance reasons?

[ggnanaraj]

Originally posted by ayeleta
Isn't 1 extent better for performance reasons?

Can you elaborate on that ?

[jovery]

Take a look at

http://asktom.oracle.com/pls/ask/f?p...:730289259844,

HTH

[DaPi]

Originally posted by ArlynSmith
Simply use an 'alter table move...' and specify a new storage clause, including a new intial extent. You do not have to move the table to a new tablespace - if you do not specify a tablespace it will be moved to a new extent in the same tablespace. This will preserve your constraints, indexes, and permissions.

I think you will need to recreate the indexes - the rowid's will have changed.