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: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Thu, 13 Feb 2003 17:32:26 GMT
Message-ID: <MPG.18b57686665a00ef9896a5@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 Thu Feb 13 2003 - 11:32:26 CST

Original text of this message

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