DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle Text installation

  1. #1
    Join Date
    Nov 2002
    Posts
    115

    Oracle Text installation

    hi all,

    we have 9.0.1 db on win2k3. It contains CTXSYS user belongs to
    Oracle Text. I am not able to create index using oracle text syntax.
    I think oracle text has n't been installed .So, how to install it ?
    Earlier we have migrated db from 8.1.5 to 9.0.1.


    Thanks for adv.
    Prasad

  2. #2
    Join Date
    Sep 2001
    Posts
    120
    i think u have the text installation,otherwise user wont be created...

    can u please put the query u using to create index..

    regards
    Saurabh Garg
    OCP 9i

  3. #3
    Join Date
    Nov 2002
    Posts
    115
    >create index idx_1 on emp(job) indextype is ctxsys.context;

    ERROR at line 1:
    ORA-29833: indextype does not exist
    Prasad

  4. #4
    Join Date
    Sep 2001
    Posts
    120
    hi,

    did u give the ctxapp role to the user from where u trying to create index.

    regards
    Saurabh Garg
    OCP 9i

  5. #5
    Join Date
    Nov 2002
    Posts
    115
    YES ,CTXAPP has been granted.
    Prasad

Posting Permissions

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


Click Here to Expand Forum to Full Width