You would have to use the intermedia for indexing them. Look at the Oracle
Intermedia section in the manual.
Jim
"Srikar" <srikarss_at_yahoo.com> wrote in message
news:33ce15a5.0107140117.5faffdcd_at_posting.google.com...
> Hi All,
> I have a table with a column of type LONG.
> Now when I try to index the table based on the long column I get a
> "ORA-00997: illegal use of LONG datatype" error.
>
> How do I go around this problem???
> Is it just impossible to create indexes on LONG data types??
> I am using Oracle 8.1.7
>
> thanx in advance,
> srikar
Received on Sat Jul 14 2001 - 10:43:10 CDT
