| alter table move [message #140768] |
Wed, 05 October 2005 09:35  |
jiewu
Messages: 2
Registered: October 2005
|
Junior Member |
|
|
|
I have a table that is 32G in size including a LOB column. And it will grow furthur. The LOB column contains image files about 150M in size. Currently it is in a tablespace with uniform extent size of 1M. I would like to move it to a tablespace with a bigger extent size, such as 16M or even bigger. Is it wise to do that? Thanks.
|
|
|
|
|
|
| Re: alter table move [message #140784 is a reply to message #140777] |
Wed, 05 October 2005 10:38  |
jiewu
Messages: 2
Registered: October 2005
|
Junior Member |
|
|
|
That is another thing I am considering. But before that I need to decide if the new tablespace should have bigger extent size.
|
|
|
|
| Re: alter table move [message #140789 is a reply to message #140768] |
Wed, 05 October 2005 11:26 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
I think there are other more important things than extent size. Partitioning should be the first thing you evaluate as mentioned. Also, if this is largely static read-only data you should use compression.
Also you may (or may not) want to put your table data and LOBS in different tablespaces. So perhaps a 1M extent is fine for the data, the lobs should be higher. You space usage/waste may increase though with larger extents.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
