OraFAQ Forum: Networking and Gateways » ORA-20000: Oracle Text error:DRG-10599: column is not indexed

Home » RDBMS Server » Networking and Gateways » ORA-20000: Oracle Text error:DRG-10599: column is not indexed

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-20000: Oracle Text error:DRG-10599: column is not indexed [message #208240]

Fri, 08 December 2006 14:47

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

Report message to a moderator

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

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

Report message to a moderator

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

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,

Report message to a moderator

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

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

Report message to a moderator

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

poratips
Messages: 345
Registered: April 2005
Location: IL

Senior Member

Thanks.

Report message to a moderator

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

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?

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	log file for connections
Next Topic:	cannot connect using oracle net_service

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 19:43:51 CST 2024