| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: change character set
I guess thisis what you are looking for
Then use the "alter database" command, this changes the current database characterset definition WITHOUT changing the actual data. Follow the steps in [NOTE:66320.1] Changing the Database Character Set or the Database National Character Set with these differences: instead of using "ALTER DATABASE CHARACTER SET <new_character_set>;" in step 3)4. use ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8; This will skip the superset check and allow you to go from AL24UTFFSS to UTF8.
The docid is
Note:234381.1
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Bobak, Mark
Sent: Tuesday, July 13, 2004 3:41 PM
To: oracle-l_at_freelists.org
Subject: RE: change character set
What version of Oracle???
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Post Hoc Ergo Propter Hoc"
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Patrick Van der Sande
Sent: Tuesday, July 13, 2004 4:33 PM
To: oracle-l_at_freelists.org
Subject: change character set
Content-Type: Text/Plain;
charset=3D"iso-8859-1"
Content-Transfer-Encoding: quoted-printable Dear,=3D0D =3D0D I am looking
for a hidden or undocumented parameter that is used to eliminate=3D0D the
super set check when a "alter dabase character set UTF8" is issued.=3D0D
Since I am running a database in WE8ISO859P1 I can not switch the charact=3D
er set=3D0D with the command above.=3D0D I know from my days at Oracle that
such a parameter exists.=3D0D Can somebody tell me what the parameter is
??=3D0D I need it quite urgently.=3D0D =3D0D I also contacted Oracle Support
but if somebody can help me in a quicker =3D way =3D2E=3D0D =3D0D
Rgds,=3D0D =3D0D Patrick Van der Sande=3D0D Managing Director =3D0D ANDES
Consulting BVBA=3D0D email : patrick.van.der.sande_at_skynet.be=3D0D
website : http://www.andes-consulting.be
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org put
 |
 |