|
-
Without specific data on your situation no specific answer can be given. Some concepts on table sizing may be helpful. Tables are created with certain inherent parameters (initial extent size, next extent size, percent increase and maxextents being the most important for your situation). These parameters may be explicitly declared for each table during table creation or, if they are not specified, they are set using the default values associated with the tablespace within which the table resides. Some of these parameters may be modified after table creation, but the modifications will apply only to new allocations. If you have a rapidly growing table, it is best to create the table with a very large initial extent so that dynamic extensions are minimized. In your situation it seems that you can either move your data into a new table with explicitly declared storage parameters appropriate for this table, its data, and its growth rate, or you could perhaps prolong the life of your existing table by increasing the value for maxextents. There are a host of remedies for table storage issues, but you should more clearly describe the problem and tell what you anticipate will limit future table growth.
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
|