Re: INTERMEDIA INDEX

From: <Jared.Still_at_radisys.com>
Date: Thu, 17 Jun 2004 11:05:24 -0700
Message-ID: <OF19C3D446.C756DB1D-ON88256EB6.006351E8-88256EB6.00635CD0@radisys.com>

from oraus.msg:

// *Cause:   An attempt was made to create an index on a non-indexable
//           expression.
// *Action:  Change the column datatype or do not create the index on an
//           expression whose datatype is one of  VARRAY, nested table, 
object,
//           LOB, or  REF.

Jared

"Seema Singh" <oracledbam_at_hotmail.com>
Sent by: oracle-l-bounce_at_freelists.org
06/17/2004 10:50 AM
Please respond to
oracle-l_at_freelists.org

To
oracle-l_at_freelists.org
cc

Subject
INTERMEDIA INDEX hi,
I want to create normal index on CLOB object.I'm able to create intermedia

indexes on that column easily but when I'm trying to create as normal it shows error "ORA-2327".

ORA-02327: cannot create index on expression with datatype LOB Any idea?
thx
-seema

Is your PC infected? Get a FREE online computer virus scan from McAfee® Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Thu Jun 17 2004 - 13:03:22 CDT