"Jeremy" <jeremy0505@gmail.com> wrote in message
news:MPG.1ee8b0737b3e593198a1ed@news.individual.ne t...
>
> create index wd_web_pages_imt on wd_web_pages (text)
> indextype is ctxsys.context
> parameters('datastore wd_wp_items_pref');
>
>
> So this text index was not created with any storage options. This is
> obviously not the corect way to do things!
>
> I know we can set the storage options by defining storage "preferences"
> but does anyone know if these can be applied retrospectively or do we
> need to drop and recreate the index? It is nearing the max extents
> default of 200 on this system.
>

For each index, Text creates a set of DR$<index_name>$<type>
tables and corresponding indexes on these tables. You are free
to alter their storage attributes as needed.

Hth,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com