When you rebuilding a index, new copy of index will be created apart
from old copy of index in the same tablespace. Once the new copy of
index is totally build old copy will be become a temp segment and SMON
does the cleanup latter.

This is what happening in your case..


Thanks and Regards,
Satheesh Babu.S
Bangalore.




-----Original Message-----
From: Sathiya
[mailto:oracledba-ezmlmshield-x80440483.[Email address protected]
Sent: Friday, July 16, 2004 10:29 AM
To: LazyDBA Discussion
Subject: Alter Index -- Syntax

Dear All,

Today we rebuilded all the indexes created in our database so
as to make the databse work faster. The command given is

ALTER INDEX UFIN.BSH_LPK REBUILD NOLOGGING TABLESPACE FIN_TAB;

(syntax same for all other Indexes and it goes to around 800+).

To our surprise, we noticed that the database size has got increased to
500 MB. We are using Oracle 8 in Windows 2000/NT.

Can anyone tell me why it is happening like that and how to bringdown
the size.

Regadrs


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page