Re: INTERMEDIA INDEX
- From: Jared.Still@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 17 Jun 2004 11:05:24 -0700
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@xxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
06/17/2004 10:50 AM
Please respond to
oracle-l@xxxxxxxxxxxxx
To
oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
