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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Probelm with Function based indexes on NVARCHAR2 columns

Re: Probelm with Function based indexes on NVARCHAR2 columns

From: Madhu Konda <konda_madhusudhan_at_yahoo.com>
Date: Wed, 27 Jul 2005 21:48:05 -0700 (PDT)
Message-ID: <20050728044806.53197.qmail@web50606.mail.yahoo.com>


Paul,
  It may not be possible immedialtey to upgrade to next 9.2 . But I'll push for it. Mean time is there a work around for me ?  

Thanks for your help,
Madhu

Paul Drake <bdbafh_at_gmail.com> wrote:
On 7/27/05, Madhu Konda wrote:
> Hi All,
> I am getting errors while trying to use function based indexes on
> NVARCHAR data type column. I have table consumer_mst
> with NAME_1 declared as NVARCHAR2(60).Our database charset is UTF-8 and
> db version is 8.1.6
>

Madhu,

upgrade to 9.2 or 10.1 and apply the latest patchsets. if that doesn't fi it, repost.
there is absolutely no excuse for running unsupported software such as 8.1.6. period.

Paul



Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 27 2005 - 23:50:09 CDT

Original text of this message

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