Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is there any way to export Oracle Text tables/indexes

1020554Feb 2 2017 — edited Feb 8 2017

I am extremely new to working with Oracle Text indexes so please be gentle

But i had performed an export dump of a production database to a non-production the other day and the developer contact me with the below error and said none of the Context indexes came over

A problem occured while searching in KeywordSearchBD.performSearch()
SQLException occurred in SearchDAO.advancedKeywordSearch():
ORA-20000: Oracle Text error: DRG-10599: column is not indexed

When I compared the two databases it showed that around 700 tables and almost 2000 indexes all with a 'DR' name did not export when i did the full dump.

These tables and indexes are not in the CTXSYS schema.

Is there any way to get these tables/indexes to Export/Import as the developers say they cannot function without them and have the Program Manager chomping at me to get it fixed.

This post has been answered by Roger Ford-Oracle on Feb 2 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 2 2017

Added on Feb 2 2017

#database-key-features, #text

5 comments

4,095 views