RE: Context/Intermedia/OracleText index rebuilds and ORA-29863

Interesting idea, Hemant! It's not perfect, but it's a better alternative than either the ORA-29863 or populating the index on the rebuild.

Thanks! :)

Rich

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Hemant K Chitale [mailto:hkchital_at_singnet.com.sg]
> Sent: Wednesday, January 15, 2003 8:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Context/Intermedia/OracleText index rebuilds and
> ORA-29863
>
>
>
> I don't know how big your Indexes are but ...
> I drop the Index and create with NOPOPULATE and then do a
> CTX_DDL.SYNC_INDEX
> which can safely run in the background [I do this for the
> lone Context Index
> in 9iFS].
> Hemant

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).