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!

How to limit the number of search results returned by oracle text

445795Jul 7 2005 — edited Mar 24 2006

Hello All,

I am running an oracle text search which returned the following error to my java program.

ORA-20000: Oracle Text error:
DRG-51030: wildcard query expansion resulted in too many terms

#### ORA-29902: Fehler bei der AusfÃ¼hrung von Routine ODCIIndexStart()
ORA-20000: Oracle Text error:
DRG-51030: wildcard query expansion resulted in too many terms
####
java.sql.SQLException: ORA-29902: Fehler bei der AusfÃ¼hrung von Routine ODCIIndexStart()
ORA-20000: Oracle Text error:
DRG-51030: wildcard query expansion resulted in too many terms

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)

When i looked up the net, one suggestion that was given is to narrow the wildcard query, which i cannot in my search page. Hence I am left with the only alternative of limiting the number of results returned by oracle text search query.

Please let me know how to limit the number of search results returned by oracle text so that this error can be avoided.

Thanks in advance
krk

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 21 2006

Added on Jul 7 2005

#database-key-features, #text

5 comments

9,300 views