Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Indexing long data type columns

Re: Indexing long data type columns

From: m.mueller <m.mueller_at_snafu.de>
Date: Sat, 21 Jul 2001 21:37:56 GMT
Message-ID: <3B501B17.CF80DFFF@snafu.de>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US