1 Reply Latest reply on Mar 11, 2014 9:31 AM by Roger Ford-Oracle

    Index document, then dispose of it

    user11973364

      Hi

       

      I'm totally new to Oracle Text, and would like to know if it might be able to fulfill a requirement that we have.

      We need the database to index a word document and then delete the document itself.

      Oracle Text should then be able to report the document as matching the search string, supplying only the document ID.

       

      In short: I want to index a document without saving the document itself.

       

      Is that possible?

       

      Jonathan

        • 1. Re: Index document, then dispose of it
          Roger Ford-Oracle

          Yes, that can be done,  Once the document is indexed, the index is usable without the original document being present.

           

          The easiest way is to use the FILE_DATASTORE, so you're storing the path/filename of the file in the database, and the indexer pulls in the document text from the file system.  Then, when your indexing is done, you can simply delete the document.

           

          Beware, though, that rebuilding the index at some future time obviously won't be possible if you don't have the original document. Also you won't be able to use certain CTX_DOC services such as FILTER, HIGHLIGHT, MARKUP or SNIPPET which rely on accessing the original document.