Clustering not working on Oracle Express?
568597Mar 22 2007 — edited May 12 2008Hi, I've been using some of the worked examples in the Oracle Documentation, which have all worked fine, however, when I try the one on clustering listed at the bottom of this page...
http://download-east.oracle.com/docs/cd/B14117_01/text.101/b10729/classify.htm
...by running the sequence of SQL through sqlplus, I get errors from the exec ctx_cls.clustering procedure. I've tried running this example on different installations of OracleExpress (Win and Linux) and others have tried the same code on their installations and we alI get the same problem.
Namely the following errors
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drctrkcg
ORA-00942: table or view does not exist
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_CLS", line 353
ORA-06512: at line 2
I know that some features in the clustering aren't availalbe in Oracle Express, but as far as I can see basic K-Means clustering should work.
I'm running Oracle Database 10g Express Edition Release 10.2.0.1.0
Anyone got an idea on this?