RE-ORG

 Hi,

I would like to re-org my database to reclaim some space and for that purpose I have used below query and now I would like to know which table space is mostly is a good candidate for the re-org.

CLEAR COLUMNS

CLEAR BREAKS

CLEAR COMPUTES

BREAK ON REPORT

COMPUTE SUM OF tbsp_size ON REPORT

COMPUTE SUM OF used ON REPORT

COMPUTE SUM OF free ON REPORT

set lines 140 pages 200 verify off

COL tbspname  FORMAT a30 HEADING 'Tablespace Name'

COL tbsp_size FORMAT 99,999,990.00 HEADING 'Size|(MB)'

COL used FORMAT 99,999,990.00 HEADING 'Used|(MB)'

COL free FORMAT 99,999,990.00 HEADING 'Available|(MB)'