Re: change database character set

aman.oracle.dba wrote:
> sybrandb wrote:
> > On Dec 12, 11:13 am, "peter" <hhh.datab..._at_gmail.com> wrote:
> > > Hi all,
> > >
> > > How to change database character set US7ASCII to UTF8 in oracle 9.2 on
> > > Sun Solaris.
> > > Please inform.
> > >
> > > Thanks
> >
> > Please read the SQL reference manual, 'ALTER DATABASE' statement.
> > Please avoid doc questions.
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
> It is there but according to that CLOB will create problem, that's why
> I am discussing here.
> Please inform how to solve the CLOB problem.

You need to export the CLOB before changing the character set, and import it after.

See "Use Scanner Utility before Altering the Database Character Set" metalink Note:123670.1
. See AL32UTF8 / UTF8 (unicode) Database Character Set Implications metalink Note:119119.1 .

If you've done something like insert 8 bit data into your 7 bit database, you will have to do more than:

1. Export the current entire database (with NLS_LANG set to <your old database character set>)
2. Create a new database in the AL32UTF8 character set
3. 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