Re: Where are my indexes.

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Fri, 7 May 1999 08:52:32 -0400
Message-ID: <7gunh3$l2q$1@autumn.news.rcn.net>

Hi Ken,

Based on your description I am not clear on what you did. Did you create
a new tablespace for the indexes? Did you remember to specify that tablespace for each of the indexes you wanted to move? If you overlooked either of theses steps your indexes will go into the default tablespace.

regards

Jerry Gitomer

Ken McClaren wrote in message <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:52:32 CDT