Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2010
    Posts
    5

    Question Unanswered: Oracle Text 11g - (interMedia Text)

    I need information of Oracle Text.?
    how to use?

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Mar 2010
    Posts
    5

    This is enough?

    Quote Originally Posted by beilstwh View Post

    I index my table_X as follows:

    CREATE INDEX ON table_X (column_X) INDEXTYPE IS CTXSYS.CONTEXT;

    This is enough?

  4. #4
    Join Date
    Dec 2003
    Posts
    1,074
    That looks like the bare minimum, yes, with some incorrect syntax. Depending upon how much data you're entering into the table per unit time, you might benefit from using the COMMIT rate statement below:

    Code:
    CREATE INDEX indexname ON tablename (columnname) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('SYNC(ON COMMIT)');


    Then you use the CONTAINS( ) function in your WHERE clause in order to utilize the index.

    There are a ton of options available to you (again, refer to the link above), but this will get you moving forward.

    --=cf

  5. #5
    Join Date
    Mar 2010
    Posts
    5

    column Blob and columnc VARCHAR

    Hi !!

    Indexing a blob field I, now search the contents of those documents.

    I have to look for 2 columns:

    -------Title--------------------------------Doc
    --The dog is wonderful-----------the_dog1.pdf
    --The dog is dog--------------------the_dog2.pdf
    --The dog-----------------------------the_dog3.pdf
    --The cat-------------------------------the_cat.pdf

    Querys:
    SEARCH TITLE:

    select TITLE, SCORE(1) s
    from IDX_BOOKS
    where contains (TITLE, :P9999_SEARCH,1) > 0
    order by s desc;
    SEARCH DOC (blob):

    select TITLE, SCORE(1) s
    from IDX_BOOKS
    where contains (DOC, :P9999_SEARCH,1) > 0
    order by s desc;

    as mix 2 query in 1 query??

    I have to use CATSEARCH?

  6. #6
    Join Date
    Dec 2003
    Posts
    1,074
    I haven't personally used CATSEARCH( ). As for having 2 references in one query ... why don't you just try it & see if it works?

    And you probably know this, but it sounds like you need 2 indexes ...

    Code:
    select TITLE
    from IDX_BOOKS
    where contains (TITLE, :P9999_SEARCH,1) > 0
      and contains (DOC, :P9999_SEARCH,1) > 0
    order by s desc;
    I took out SCORE(1) since I'm not sure how that works when 2 CONTAINS( ) are in one WHERE clause.

    --=cf

  7. #7
    Join Date
    Mar 2010
    Posts
    5
    You query fails!
    ORA-29907: found duplicate labels in primary invocations

    My index:

    --COLUMN VARCHAR:
    CREATE INDEX idx_books_title ON IDX_BOOKS (title) INDEXTYPE IS CTXSYS.CONTEXT parameters ('sync (on commit)');

    --COLUMN BLOB:
    CREATE INDEX idx_books_doc ON IDX_BOOKS (doc) INDEXTYPE IS CTXSYS.CONTEXT parameters ('sync (on commit)');
    --

  8. #8
    Join Date
    Dec 2003
    Posts
    1,074
    Dunno dude ... just trying to help you along ...

    Code:
    select TITLE
    from IDX_BOOKS
    where contains (TITLE, :P9999_SEARCH,1) > 0
    union
    select TITLE
    from IDX_BOOKS
    where contains (DOC, :P9999_SEARCH,1) > 0
    order by 1;

  9. #9
    Join Date
    Mar 2010
    Posts
    5
    Mmmm...
    this is good for searches with large amount of data?

    Must be another way...
    ALSO THANK YOU FOR YOUR HELP"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •