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
At 09:29 AM 14-01-03 -0800, you wrote:
Hey all, Spent last night (til the Witching Hour) patching from 8.1.7.2 to 8.1.7.4. During the process, we had all three of our Context indexes trashed. My guess is that it was because CTXSYS.CTX_DDL.INDEX_SYNC() DBMS_JOB was running while the CTX upgrade scripts were running. I thought it was funny that there were no instructions to break this job before the upgrade, but it did work in test back in September. Anyway, I filed a TAR, and after re-running the "dr0" admin scripts, we tried to rebuild the indexes online using: ALTER INDEX my_context_index REBUILD ONLINE; Alas, the error: ORA-29863: Warning in the Execution of ODCIINDEXCREATE Routine reared it's ugly puss. We checked the advice of the Metalink article on the error, but we didn't have any of those symptoms (out of Temp or Perm TS space) and ended up dropping and recreating the indexes. So, has anyone run across this error before? I'd hate to think I'm not able rebuild indexes, much less online... TIA! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).