Release space from tablespace

60 Views

Dear Experts,

We are using oracle database 10G. one particular tablespace is of 1.5 TB . We have to free around 500 GB .Plesae let me know how to proceed for this .When i checked in brtools i see followig output regarding that tablespace.

1 - Tablespace type (type) ................... DATA

2 - Tablespace status (status) ............... ONLINE

3 - Extent management (extent) ............... LOCAL

4 - Segment space managenent (space) ......... MANUAL

5 - Backup status (backup) ................... NO

6 - Number of files in tablespace (files) .... 281

7 - Number of autoextensible files (autoext) . 0

8 - Total tablespace size in KB (total) ...... 3379782080

9 - Used space in tablespace in % (used) ..... 54.83

10 - Free space in tablespace in KB (free) .... 1526570432

11 - Maximum tablespace size in KB (maxsize) .. 3379782080

12 - Maximum extension size in KB (extsize) ... 0

13 - Allocated disk space in KB (space) ....... 3379786496

14 - Number of free extents (freext) .......... 63676

15 - Largest free extents (largest) ........... 4063232:4063232:4063232:3883008:3809280

Appreciate your help for quick response .Please let know how to plan for this activity as well.

Thanks ,

Arun