Re: change database character set

peter wrote:
> joel garry wrote:
> >
> > If you've done something like insert 8 bit data into your 7 bit
> > database, you will have to do more than:
> >
> > a. Export the current entire database (with NLS_LANG set to <your old
> > database character set>)
> > b. Create a new database in the AL32UTF8 character set
> > c. Import all data into the new database (with NLS_LANG set to <your
> > old database character set>)
> >
> > jg
> > --
> > @home.com is bogus.
> > http://www.signonsandiego.com/uniontrib/20061211/news_1n11sales.html
> I am facing these problem : -
>
> SQL> ALTER DATABASE CHARACTER SET AL32UTF8;
> ALTER DATABASE CHARACTER SET AL32UTF8
> *
> ERROR at line 1:
> ORA-12716: Cannot ALTER DATABASE CHARACTER SET when CLOB data exists
>

Sorry, that should have been UTF8, if that's what you want.

Obviously, you can't use the alter command. You have to export, create a new db with the new characterset, and import. But before you do, be sure there aren't any 8 bit characters in your database. It is possible for tools to insert things like "ein was für großes Jahr für den Superman!" into your seven bit database but they will be helpfully debitted by exp/imp.

jg

--
@home.com is bogus.
http://www.wired.com/wired/archive/14.12/posts.html?pg=6