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

Hi,

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.

Cheers..

Legend

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