From oracle-l-bounce@freelists.org Thu Mar 4 02:43:45 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i248hjk02873 for ; Thu, 4 Mar 2004 02:43:45 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i248hVo02856 for ; Thu, 4 Mar 2004 02:43:31 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B152E394FB1; Thu, 4 Mar 2004 03:42:58 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 04 Mar 2004 03:41:50 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mxsf20.cluster1.charter.net (mxsf20.cluster1.charter.net [209.225.28.220]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E3FA4394D26 for ; Thu, 4 Mar 2004 03:41:46 -0500 (EST) Received: from neltox (24-205-232-204.slo-cres.charterpipeline.net [24.205.232.204]) by mxsf20.cluster1.charter.net (8.12.10/8.12.8) with ESMTP id i248hTGc086162 for ; Thu, 4 Mar 2004 03:43:30 -0500 (EST) (envelope-from nflores@expand.cl) From: "Nelson Flores" To: Subject: index refresh as job Date: Thu, 4 Mar 2004 00:44:41 -0800 Message-ID: <008801c401c4$f1080930$cce8cd18@neltox> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0089_01C40181.E2E4C930" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-archive-position: 284 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: nflores@expand.cl Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------=_NextPart_000_0089_01C40181.E2E4C930 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi list, It's late and I'm in a little bit of a pickle . The problem is synchronizing a text index using a job. I create the job fine, but I query user_jobs, and I keep on getting failures . I create the job (with suitable account privs) with the following. DECLARE v_jobno number; BEGIN dbms_job.submit(job=>v_jobno, what=>'ctx_ddl.sync_index(''"FOOBAR"."SEARCH_IDX"'' );', next_date=>sysdate+1/24, interval=>'sysdate+1/24'); END; The job is created fine. I run exec ctx_ddl.sync_index('"FOOBAR"."SEARCH_IDX"'); and it works fine and dandy, but every time the job is invoked it returns an error. Anyone have any ideas ? Is there a better way to do this???? (I hate having to depend on a job for this) BTW I'm doing this on my laptop which is 9.2.0.1.0 on Win XP.. Thanks in advance Nelson ------=_NextPart_000_0089_01C40181.E2E4C930 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi list,

It’s late and I’m in a little bit of a = pickle …

The problem is synchronizing a text index using a = job. I create the job fine, but I query user_jobs, and I = keep on getting failures …

I create the job (with suitable account privs) with the following…

&nbs= p; DECLARE<= /p>

= v_jobno number;

= ; BEGIN

= ; &nbs= p; dbms_job.submit(job=3D>v_jobno, =

&nbs= p; = ; what=3D>'ctx_ddl.sync_index(''"FOOBAR"."SEARC= H_IDX"'' );',

&nbs= p; = ; next_date=3D>sysdate+1/24,

&nbs= p; = ; interval=3D>'sysdate+1/24');

= ; END;

The job is created fine.

I run exec ctx_ddl.sync_index('"FOOBAR"."SEARCH_IDX”’)= ; and it works fine and dandy, but every time the job is invoked it = returns an error. Anyone have any ideas = ?

Is there a better way to do this???? (I hate having = to depend on a job for this)

BTW I’m doing this on my laptop which is = 9.2.0.1.0 on Win XP….

Thanks in advance

Nelson

------=_NextPart_000_0089_01C40181.E2E4C930-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------