Confusing CTXSYS issue
From: macdba321 <macdba321_at_gmail.com>
Date: Wed, 16 Sep 2009 08:51:49 -0700 (PDT)
Message-ID: <a4d639cd-7aab-4bf7-bf9b-1bfcf31c8f7f_at_z28g2000vbl.googlegroups.com>
Version: 10.2.0.3.0
Platform: Win2003 SP2 64-bit
Date: Wed, 16 Sep 2009 08:51:49 -0700 (PDT)
Message-ID: <a4d639cd-7aab-4bf7-bf9b-1bfcf31c8f7f_at_z28g2000vbl.googlegroups.com>
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")');
Received on Wed Sep 16 2009 - 10:51:49 CDT