Can we do the cleanup procedure manually now.... If not when
SMON will do the process !!!

----- Original Message -----
From: "Satheesh" <oracledba-ezmlmshield-x22598333.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, July 16, 2004 10:38 AM
Subject: RE: Alter Index -- Syntax


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