Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Text Indexes: Extent specification/management
In article <e5m81q$igi$1_at_hypnos.nordnet.ru>, Vladimir M. Zakharychev
says...
>
> "Jeremy" <jeremy0505_at_gmail.com> wrote in message
> news:MPG.1ee8b0737b3e593198a1ed_at_news.individual.net...
> > 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.
>
>
Many thanks Vladimir.
-- jeremyReceived on Thu Jun 01 2006 - 04:53:19 CDT
![]() |
![]() |