Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Indexing long data type columns
Please look at the SQL Reference, in chapter2, 'Basic Elements of OracleSQL', 'Datatypes', 'Long Datatype' you find restrictions. One of the restrictions is 'Long columns cannot be indexed'. Oracle recommends using the 'LOB' datatype.
Hope that helps
Manuela
Received on Sat Jul 21 2001 - 16:37:56 CDT