Re: Confusing CTXSYS issue
From: ddf <oratune_at_msn.com>
Date: Wed, 16 Sep 2009 09:18:00 -0700 (PDT)
Message-ID: <59308df0-b83b-4c6a-b4b1-62a443ade3b8_at_d4g2000vbm.googlegroups.com>
On Sep 16, 10:51 am, macdba321 <macdba..._at_gmail.com> wrote:
> Version: 10.2.0.3.0
> Platform: Win2003 SP2 64-bit
>
> Hello,
> I created a context index. It has a sync every 24 hours on it, but
> it does not seem to be automatically syncing now. (If I "call
> ctx_dll.sync_index" on it, it works great.)
>
> How can I verify that it is registered to continue to re-sync? A
> "select * from dba_jobs" returns 0 results.
>
> Thank you.
>
> FYI: This is the create index syntax:
>
> create index idx_ry_resource_meta on ry_resource (m_extensions)
> indextype is ctxsys.context parameters
> ('FILTER CTXSYS.NULL_FILTER SECTION
> GROUP CTXSYS.NULL_SECTION_GROUP
> SYNC (EVERY "TRUNC(SYSDATE)+1")');
Have you checked DBA_SCHEDULER_JOBS for an entry?
Date: Wed, 16 Sep 2009 09:18:00 -0700 (PDT)
Message-ID: <59308df0-b83b-4c6a-b4b1-62a443ade3b8_at_d4g2000vbm.googlegroups.com>
On Sep 16, 10:51 am, macdba321 <macdba..._at_gmail.com> wrote:
> Version: 10.2.0.3.0
> Platform: Win2003 SP2 64-bit
>
> Hello,
> I created a context index. It has a sync every 24 hours on it, but
> it does not seem to be automatically syncing now. (If I "call
> ctx_dll.sync_index" on it, it works great.)
>
> How can I verify that it is registered to continue to re-sync? A
> "select * from dba_jobs" returns 0 results.
>
> Thank you.
>
> FYI: This is the create index syntax:
>
> create index idx_ry_resource_meta on ry_resource (m_extensions)
> indextype is ctxsys.context parameters
> ('FILTER CTXSYS.NULL_FILTER SECTION
> GROUP CTXSYS.NULL_SECTION_GROUP
> SYNC (EVERY "TRUNC(SYSDATE)+1")');
Have you checked DBA_SCHEDULER_JOBS for an entry?
David Fitzjarrell Received on Wed Sep 16 2009 - 11:18:00 CDT