If you delete a lot of data, the entry in index will not be deleted, that is
why index will take more space than the data it self.
Alter index rebuild will solve the problem.
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:unr42ln5g5cjfc_at_corp.supernews.com...
>
> "Ora" <ora_geek_at_yahoo.com> wrote in message
> news:fa5d6718.0209092108.7cacba74_at_posting.google.com...
> > I administer an OLTP database.
> >
> > I have separate tablespaces on different Disk for Table data and index
> > Objetcts .
> >
> > FOr one Module, the Space used in Index Tablespace is almost double
> > than that of the corresponding Data Tablespace.
> >
> > Is it possible that Index objects occupy such large space vis-a-visa
> > its Table Data ?
> >
> > OrA
>
> This is quite normal
>
> Hth
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
>
Received on Tue Sep 10 2002 - 06:37:55 CDT
