Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-22866 & CLOB
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...Received on Fri Feb 14 2003 - 15:20:23 CST
> 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
![]() |
![]() |