4 Replies Latest reply: Oct 16, 2013 4:42 AM by 936749 RSS

    ORA-00904: "CTX_REPORT"."DESCRIBE_INDEX": invalid identifier



      After moving a database(schemas) with Data Pump I've experienced that the Oracle text context isn't moved.

      When querying dba_context I can see the context in source database but not in target database.


      Was looking through the documentation but this isn't my strongest area within Oracle.

      I tried to create the index sxript as following:


      select ctx_report.describe_index('my_ctx_idx')from dual;

      ERROR at line 1:

      ORA-00904: "CTX_REPORT"."DESCRIBE_INDEX": invalid identifier


      Also how can I create the context in my target database? As far as I understand the index it self is moved???

      How can I find Oracle text indexes in my database?


      I've read through 189819.1 and http://docs.oracle.com/cd/B28359_01/text.111/b28304/crptpkg.htm

      Need help.