0

Is it at all possible to add a working fulltext index on a mediumtext field in oracle? I have been able to make an index, but I do not get any results when I query it. It might be that my sql is flawed: (ps. I am absolutely sure that the 'someText' part is in the DB).

SELECT *
FROM Products
WHERE CONTAINS (ProductDescription, 'someText' );

I also tried with:

SELECT *
FROM Products
WHERE CONTAINS (ProductDescription, 'someText' )>0;

But no results.

The strange thing is that the query returns no error, it simply does not return results. It might be that my index is inproperly created, but in "phpMyAdmin" it is listed as one of the indexes for my table. Any ideas?

Automatico
  • 12,420
  • 9
  • 82
  • 110
  • Doesn't sound like Oracle when you say phpMyAdmin, fulltext and mediumtext - sounds more like a MySQL database? – Datajam May 21 '11 at 12:17
  • Yeah, accually it might be:p My bad. A help-link in phpMyAdmin directed me to a oracle site, so I was not sure. Probably because they bought sun. – Automatico May 21 '11 at 14:11

1 Answers1

0

How have you built your index ?

Specifically, are you syncing the index changes to the table changes ON COMMIT

Gary Myers
  • 34,963
  • 3
  • 49
  • 74
  • I do believe that the index is buldt. I am not, however, syncing t. Do you have an example of how to add the sync after the index is made? (the index is quite big, so I dont want to have to create it all over again). – Automatico May 21 '11 at 14:19