This discussion is archived
4 Replies Latest reply: Oct 16, 2013 2:42 AM by 936749 RSS

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

936749 Newbie
Currently Being Moderated


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

Need help.



  • Correct Answers - 10 points
  • Helpful Answers - 5 points