View previous topic :: View next topic
|
Author |
Message |
babu_hi
New User
Joined: 11 Apr 2006 Posts: 93
|
|
|
|
I want to increase Table space,It is possible thru Alter statement or ia there any other way to Incrase The Table Space? |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
Back to top |
|
|
ravi17s Warnings : 1 New User
Joined: 15 Aug 2003 Posts: 57
|
|
|
|
You cannot use ALTER TABLESPACE to change some attributes of your table
space. For example, you must use other methods to change SEGSIZE or the
number of partitions or to convert it to a large table space. The following topics
describe these methods:
There are different ways in which u can increase the space.
traditionla way of:
Unload
DROP
RECREATE
LOAD
Remeber the all the tables in the tablespace should also be dropped and recreated
Or the simpler way of using RE-ORG
-----------------------------------------
Changing the space allocation for user-managed data sets
If the table space is supported by user-managed data sets, use this procedure to
change the space allocation:
1. Run the REORG TABLESPACE utility, and specify the UNLOAD PAUSE
option.
2. Make the table space unavailable with the STOP DATABASE command and the
SPACENAM option after the utility completes the unload and stops.
3. Delete and redefine the data sets.
4. Resubmit the utility job with the RESTART(PHASE) parameter specified on the
EXEC statement.
The job now uses the new data sets when reloading.
Use of the REORG utility to extend data sets causes the newly acquired free space
to be distributed throughout the table space rather than to be clustered at the end. |
|
Back to top |
|
|
babu_hi
New User
Joined: 11 Apr 2006 Posts: 93
|
|
|
|
Thanks Ravi. |
|
Back to top |
|
|
|