Home » » How to reduce size of tablespace

How to reduce size of tablespace

Written By 1 on Friday, April 15, 2011 | 10:04 PM


If temp is the tablespace that need to be reduced
 
1. Create new temp1 tablespace
2. Make new temp1 tablespace as default
3. Drop the temp tablespace
4. create  temp tablespace
5. Make the temp tablepsace as default
6. Drop  temp1  tablespace..


0 Comment:

Post a Comment