Hi Gurus,

I am going to Rebuild some of the indexes in our database. I have given the space available in the system,temp and the tablespaces where the indexes are there. Pls guide me whether the tablespaces having enough space to rebuild or not? What r the steps i need to do before rebuild? Thanks in advance.

system tablespace having 155MB freespace.
Temp tablespace having 2475MB freespace.

ds_default_ts has 7 datafiles , which is having freespace of totally 769MB.
ds_index_ts has 5 datafiles, which is having freespace of totally 7477MB.
ds_txn_ts has 7 datafiles, which is having freepspace of totally 1473MB.
ds_par_ts has 4 datafiles, which is having freespace of totally 248MB.


I have given the existing size of the indexes below.

Tablespace Indexes size
---------- ------- -----

ds_default_ts - IDX_PAYTXNPERF 405MB
IDX_PAYSTATPERF 223MB
PK_DS_PAY_STATUSES 111MB
IDX_OATCUSTIDACCTNO 456MB
IDX_OABCUSTIDACCTNO 350MB
SYS_C0061007 833MB
------
TOTAL 2378MB
------

ds_index_ts - IDX_DS_PAY_TXNS 143MB
IDX_PERF_DS_OA_TXNS 503MB
SYS_C0058752 668MB
DS_OA_BALANCES_IDX4 207MB
IDX_CUSTACCT 225MB
SYS_C0058758 1512MB
XIF18DS_OA_BALANCES 750MB
XIF19DS_OA_BALANCES 309MB
XIF17DS_PAY_INVOICE_DTLS 169MB
XIF22DS_PAY_EXCEPTIONS 2MB
------
4488MB
------

ds_txn_ts - SYS_C0058757 77MB
XIF16DS_PAY_STATUSES 80MB
SYS_C0058753 191MB
SYS_C0030685 0.3 (311296 bytes)
SYS_C0030690 0.73 (761856 bytes)
SYS_C0030681 1.5MB
SYS_C0031608 494MB
------
844.53MB
------

ds_par_ts - XIF19DS_PAY_FXCONTRACT_DTLS 0.58 (606208 bytes)
XIF18DS_PAY_DOC_CHECKLISTS 1.31MB
------
1.89MB
------

Rgds,

Saravanan.