Oracle text was born as the context option which cost money. It was = then renamed Intermedia with the 8.0 rdbms release and still cost money. = Howevever with the 8.1 rdbms release folks holding EE licenses could = use Intermedia without charge. Intermedia was renamed Oracle Text with = the 9.0 rdbms release. Ian MacGregor Stanford Linear Accelerator Center ian@xxxxxxxxxxxxxxxxx -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx = [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still Sent: Tuesday, October 26, 2004 10:09 PM To: rich.jesse@xxxxxxxxxxxxxxxxx Cc: Oracle Discussion List Subject: Re: How to search on LONG datatype column On Tue, 26 Oct 2004 14:43:57 -0500, Jesse, Rich = <rich.jesse@xxxxxxxxxxxxxxxxx> wrote: > The setup is still a but tricky and try to find resources for creating = > a =3D stoplist, but it works great for us. I'm not sure about LONG=20 > support, =3D but it will work with CLOBS. >=20 Oracle Text works just fine with LONGS. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l