Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Text Indexes: Extent specification/management

Re: Text Indexes: Extent specification/management

From: Jeremy <jeremy0505_at_gmail.com>
Date: Thu, 1 Jun 2006 10:53:19 +0100
Message-ID: <MPG.1ee8c96063e398c198a1ee@news.individual.net>


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.

-- 

jeremy
Received on Thu Jun 01 2006 - 04:53:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US