-
Originally posted by jovery
Why do you want to move the data to a single extent?
Jeff Hunter
-
Isn't 1 extent better for performance reasons?
Isn't 1 extent better for performance reasons?
-
Re: Isn't 1 extent better for performance reasons?
Originally posted by ayeleta
Isn't 1 extent better for performance reasons?
Can you elaborate on that ?
-
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|