DATA BASE Character set

[smdakram]

Hi ,


We r using Oracle 9.2 on solaris 9 Machine.

1.I export full DB (Character set mode AL16UTF16)
2.I Created New DB (Character set mode is UTF8 )
3.Imported full DB SUCCESSFULY.

But error is when users r accessing DB using TOAD application
ORA-01460: unimplemented or unreasonable conversion requested.

I know that when i import DB it import in UTF8 Character mode.

I SHUTDOWN the DB
I try to change the DB Character set mode to AL16UTF16.
But my database contain CLOB DATA .

{This restriction on using the ALTER DATABASE CHARACTER SET statement arises because of CLOB data. In Oracle9i, some internal fields in the data dictionary are stored in CLOB columns}

How to change my DB Character set mode.

akram shaik .

[akhadar]

Before creating any database u have decide carefully your requirement about character set.If u want to change the character set afterwards it is strongly adviced by Oracle to be done under their supervision as dealing with data which is deadly.