Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-22866 & CLOB
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.
-- /KarstenReceived on Thu Feb 13 2003 - 11:32:26 CST
![]() |
![]() |