Results 1 to 3 of 3

Thread: IndexType ?

  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: IndexType ?

    Hi,

    I can't understand the concept of INDEXTYPE ? Please explain it clearly with some examples ?

    CREATE INDEX index1 ON test_table(col1) INDEXTYPE IS CTXSYS.CONTEXT

    What does the above statement infer ? ( Regarding INDEXTYPE ...)

    Thanks,
    Sam

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    This specifies that the index is not a "normal" Oracle index but is a "domain" index, the workings of which are defined by a "data cartridge" probably supplied by Oracle (like Oracle Text) or a third party.

    For more details...

    http://download-west.oracle.com/docs...a96595/toc.htm

  3. #3
    Join Date
    Mar 2004
    Posts
    205
    Thanks for your information.

Posting Permissions

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