Re: Where are my indexes.

Do you have some activity that might rebuild your indexes, possible as part of a performance improvement practice? This is quite easy with newer versions of Oracle. Is this a packaged solution the insides of which you cannot see?

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)

                        <KevinALewis_at_HotMail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. Ken McClaren <default_at_nowhere.com> wrote in message news:926035061.113.6_at_news.remarQ.com...
> I have just completed a small project to move my indexes out of my
USER_DATA
> file and into a separate USER_IDX file. Wrote a script to move each index
to
> it's new location. Yet after a few days I find that the index file is
nearly
> empty <16MB and all of my indexes have relocated to the USER_DATA file
> again. What could be causing this? I do a cold backup nightly. Shut the
> database down and copy all the files to a test server. I have not
attempted
> an Import/Export. What could be going on?
>
> Please copy my email on any response.
> KenMc_at_kayaker.com
> Tks
>
>
Received on Fri May 07 1999 - 07:14:34 CDT