How to reduce size of tablespace

 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..