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

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-22866 & CLOB

Re: ORA-22866 & CLOB

From: Alexander Fedorov <lamer2000_at_hotmail.com>
Date: Fri, 14 Feb 2003 16:20:23 -0500
Message-ID: <b2jn0q$k6i$1@selma.aspentech.com>


Looks like this was the reason for my problem. Thank you very much!

--
Sincerely, Alexander Fedorov

"Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message
news:MPG.18b57686665a00ef9896a5_at_news.la.sbcglobal.net...

> lamer2000_at_hotmail.com said...
> > > The compatible parameter for your database is set to 8.0.5 (or lower).
> > > Edit the init.ora parameter file with a compatible parameter of 8.1.0
or
> > > higher. Your database has a character set of UTF8, a variable width
> > > character set. In versions previous to Oracle8i, this restricted the
use
> > > of CLOB datatypes.
> >
> > Thanks a lot! Do you know where can I find this thing in in DBA Studio?
> >
> > --
> > Sincerely, Alexander Fedorov
> >
>
> Sure. Look at <tree> / Instance / Database / General tab. Click the
> pushbutton labelled All Initialization Parameters. Look at the value of
> the "compatible" parameter. Of course, you'll also notice that it's
> *not* a dynamic parameter - which means you have to edit your
> initsid.ora file, change it, then bounce your database.
> --
> /Karsten
Received on Fri Feb 14 2003 - 15:20:23 CST

Original text of this message

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