Re: Oracle8 Context Cartridge error on rebuild of indexes

From: <thiko_at_my-deja.com>
Date: 2000/08/03
Message-ID: <8mbbud$c2q$1@nnrp1.deja.com>#1/1

Will, copy of the script:
echo "STARTED: "
date

echo "*********************************************"

echo "* Set the user environment for the cron job *"

echo "*********************************************"

. /$HOME/.profile

ORACLE_SID=ORA
export ORACLE_SID

echo "*******************************************"
echo "* Rebuild Context indexes                 *"
echo "*******************************************"

/disk1/svrmgrl << EOF
CONNECT newsonlinedb/leafmold_at_ora
# SET SERVEROUTPUT ON
execute ctx_ddl.optimize_index('NewsBody', ctx_ddl.defragment_to_new_table);
execute ctx_ddl.optimize_index('NewsHeadline', ctx_ddl.defragment_to_new_table);
execute ctx_ddl.optimize_index('NewsSummary', ctx_ddl.defragment_to_new_table);
execute ctx_ddl.optimize_index('NewsDescription', ctx_ddl.defragment_to_new_table);
execute ctx_ddl.optimize_index('NewsSlug', ctx_ddl.defragment_to_new_table);
EOF echo "FINISHED: "
date

In article <Qa6i5.3146$2k6.395291_at_news.uswest.net>,   "Will Darton" <azsportbike_at_yahoo.com> wrote:
> I'll assume you are running a script to do that, so could you maybe
 give a
> copy of the script?
>
> Will Darton
> Oracle DBA
> <thiko_at_my-deja.com> wrote in message

 news:8m8pja$ecl$1_at_nnrp1.deja.com...
> > Hi we rebuild our context indexes twice a month and it has not
 worked
> > once so far. We keep getting the following error in the log. Does
> > anyone know what the problem/solution might be? Short of droping
 the
> > indexes and rebuilding them...
> >
> > Many thanks
> >
> >
> > *******************************************
> > * Rebuild Context indexes *
> > *******************************************
> >
> > Oracle Server Manager Release 3.0.5.0.0 - Production
> >
> > (c) Copyright 1997, Oracle Corporation. All Rights Reserved.
> >
> > Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
> > With the Partitioning and Objects options
> > PL/SQL Release 8.0.5.2.0 - Production
> >
> > SVRMGR> Connected.
> > SVRMGR> SVRMGR> ORA-20000: ConText error:
> >
> > ORA-06512: at "CTXSYS.DRUE", line 180
> > ORA-06512: at "CTXSYS.CTX_DDL", line 722
> > ORA-06512: at line 2
> > SVRMGR> Statement processed.
> > SVRMGR> Statement processed.
> > SVRMGR> Statement processed.
> > SVRMGR> Statement processed.
> > SVRMGR>
> > Server Manager complete.
> > FINISHED:
> > Tue Aug 1 02:06:50 GMT 2000
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 03 2000 - 00:00:00 CDT