Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: interMedia
Why some of the pdf's are indexing properly and why others not? I just used
the same acrobat version in converting our documents.
Yes, I have a procedure to synchronize and I run it as a job to periodically update my index. Procedure below:
procedure sync_archive
is
begin
execute immediate
'alter index archive_idx rebuild online' || ' parameters ( ''sync'' )' ; execute immediate 'alter index archive_idx rebuild online' ||' parameters ( ''optimize full maxtime unlimited'' )' ; end sync_archive;
Yes, even if I added the INSO_FILTER in my index DDL, problem still the same.
Thanks for the help.
Regards,
Arman
"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message
news:a9ggia$m9e$1_at_babylon.agtel.net...
> select count(*) from ctx_user_pending
>
> if this is > 0 then you need to synchronize your index. Either start
ctxsrv (not
> recommended and not available as of 9i) or create a job which will do it
regularly.
> The code for the job could be like this:
>
> begin
> for idx in (select distinct pnd_index_name name from ctx_user_pending)
loop
> ctx_ddl.sync_index(idx.name);
> end loop;
> end;
>
> Your PDF files also can be of version newer than that supported by your
version
> of the interMedia Text. And from your index DDL I see you didn't specify
> INSO_FILTER as document filter - if this is not your default filter,
compressed
> PDF files will not be properly indexed.
>
> --
> Vladimir Zakharychev (bob_at_dpsp-yes.com)
http://www.dpsp-yes.com
> Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
applications.
> All opinions are mine and do not necessarily go in line with those of my
employer.
>
>
> "acelestial" <acelestial_at_twp.cwellington.on.ca> wrote in message
> news:trFu8.11538$EG2.65193067_at_radon.golden.net...
> > Hi,
> >
> > I have a table with BLOB field. I've created an index on the BLOB field
> > using the ff.:
> >
> > create index tablename_idx on tablename(BLOBfield)
> > indextype is ctxsys.context;
> >
> > I used the Oracle8i interMedia Text Query to display the result in an
asp
> > page. The query is something like this:
> >
> > select id, blobfield, score(1)
> > from tablename
> > where contains ( BLOBfield, '%parameter%', 1) > 0;
> >
> > The problem is somehow some of the records/BLOB are not being index. Is
> > there any problem on the documents that I uploaded in the BLOB field or
is
> > it something else? The documents that I'm uploading are usually PDF
files.
> >
> > Thank you very much for the help.
> >
> > Regards,
> > Arman
> >
> >
> >
>
Received on Thu Apr 18 2002 - 14:19:50 CDT