Quote:
Originally posted by jovery
Why do you want to move the data to a single extent?
Printable View
Quote:
Originally posted by jovery
Why do you want to move the data to a single extent?
Isn't 1 extent better for performance reasons?
Can you elaborate on that ?Quote:
Originally posted by ayeleta
Isn't 1 extent better for performance reasons?
Take a look at
http://asktom.oracle.com/pls/ask/f?p...:730289259844,
HTH
I think you will need to recreate the indexes - the rowid's will have changed.Quote:
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.