is fin_tab DMT or LMT ... i guess its DMT ... u manually have to colasce
it ...

Deepa Kale -DBA
Jyoti Structures - Nasik(IT)



"Sathiya "
<oracledba-ezmlmshield-x80440483.[Email Address Removed] To: "LazyDBA Discussion" <[Email address protected]
azyDBA.com> cc:
Subject: Alter Index -- Syntax
16-07-2004 10:28 AM






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