Home » RDBMS Server » Networking and Gateways » ORA-20000: Oracle Text error:DRG-10599: column is not indexed
ORA-20000: Oracle Text error:DRG-10599: column is not indexed [message #208240] Fri, 08 December 2006 14:47 Go to next message
poratips
Messages: 345
Registered: April 2005
Location: IL
Senior Member
Hi,
We are using ATG Dynamo on ORacle 9i R2 and we are having issue when we search the text out of ATG dynamo box, getting error:
ORA-20000: Oracle Text error:DRG-10599: column is not indexed
We don't build the code as it comes with ATG dynamo JAVA code.
Any Idea?
We have already have index on DESCRIPTION column and created context index (INDEXTYPE IS CTXSYS.CONTEXT) which using oracle text and also checked that oracle text is properly configured.


CREATE TABLE PRODUCT
(
PRODUCT_ID VARCHAR2(40 BYTE) PK NOT NULL,
VERSION NUMBER,
c_DATE DATE,
S_DATE DATE,
END_DATE DATE,
DISPLAY_NAME VARCHAR2(254 BYTE),
DESCRIPTION VARCHAR2(254 BYTE),
LONG_DESCRIPTION CLOB,
)
Mostly using column in my query is product_id, DISPLAY_NAME, DESCRIPTION, LONG_DESCRIPTION.
PRODUCT_ID has pk index, DESCRIPTION has Non Unique Index and LONG_DESCRIPTION has context index.

Thanks,
Poratisp
Re: ORA-20000: Oracle Text error:DRG-10599: column is not indexed [message #208270 is a reply to message #208240] Fri, 08 December 2006 23:51 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,

ORA-20000: %s
Cause: The stored procedure 'raise_application_error' was called which causes this error to be generated.
Action: Correct the problem as described in the error message or contact the application administrator or DBA for more information.



ora-20000 to ora-20999 is reserved for user_error ( define by manully) by application dba or dba. through "raise_application_error" clause.


regards
taj
Re: ORA-20000: Oracle Text error:DRG-10599: column is not indexed [message #208323 is a reply to message #208270] Sat, 09 December 2006 09:12 Go to previous messageGo to next message
poratips
Messages: 345
Registered: April 2005
Location: IL
Senior Member
Thanks Taj.
We are not running any pl/sql here. It's from application server which itself has Java code.

Thanks,
Re: ORA-20000: Oracle Text error:DRG-10599: column is not indexed [message #208565 is a reply to message #208240] Mon, 11 December 2006 06:04 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

If you have metalink available , there are alot of hint's for solving your problem.....have a look.

Best of luck
Re: ORA-20000: Oracle Text error:DRG-10599: column is not indexed [message #209233 is a reply to message #208565] Wed, 13 December 2006 22:40 Go to previous messageGo to next message
poratips
Messages: 345
Registered: April 2005
Location: IL
Senior Member
Thanks.
Re: ORA-20000: Oracle Text error:DRG-10599: column is not indexed [message #264776 is a reply to message #208240] Tue, 04 September 2007 10:06 Go to previous messageGo to next message
me_gautam
Messages: 1
Registered: September 2007
Junior Member
I guess it is some time but just in case did you find any solution to that problem?
Re: ORA-20000: Oracle Text error:DRG-10599: column is not indexed [message #264786 is a reply to message #264776] Tue, 04 September 2007 10:27 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think this:
tahpush wrote on Mon, 11 December 2006 13:04
If you have metalink available , there are alot of hint's for solving your problem.....have a look.

Best of luck

is the answer.

Regards
Michel
Previous Topic: log file for connections
Next Topic: cannot connect using oracle net_service
Goto Forum:
  


Current Time: Sat Dec 10 03:24:34 CST 2016

Total time taken to generate the page: 0.06572 seconds