| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Changing character set.
On Thu, 09 Dec 1999 12:21:33 +0100, you wrote:
><!doctype html public "-//w3c//dtd html 4.0 transitional//en">
><html>
>You can also change the database character set by updating the table SYS.PROPS$.
><br>But you must be very careful. If you update this table using an INVALID
>value, you cannot start up the database.
if you value your data and having support, you will *not* even think about doing this. If you do this and you have data that does not fit into your characterset -- watch out, can you spell ORA-600?
bad idea.
><p>Here are steps to change the characterset
><br>1) Make a cold and clean backup of the database
><br>2) Backup the current table sys.props$
><p>SQL> create table sys.props$_old
><br> 2 as select * from sys.props$;
><p>Table created.
><p>Check the current character set
><br>SQL> select name, value$ from sys.props$;
><p>4) Change the character set to WE8ISO8859P1
><p>SQL> update sys.props$
><br> 2 set value$='WE8ISO8859P1'
><br> 3 where name='NLS_CHARACTERSET';
><p>If you use Oracle8, you need to update the national characterset as
>well.
><p>SQL> update sys.props$
><br> 2 set value$='WE8ISO8859P1'
><br> 3 where name='NLS_NCHAR_CHARACTERSET';
><p>Then save the data
><br>SQL> COMMIT;
><p>Remark: you can query SYS.GV_$NLS_VALID_VALUES for valid values
>of characterset and other NLS values.
><p>4) Restart the database. The new characterset will be enabled.
><p>Good luck
><p>Cong Tang
><br>------------------
><br>CTBTO
><br>Vienna, Austria
><p>vijaylamba_at_my-deja.com wrote:
><blockquote TYPE=CITE>hi
><br>take complete backup of all your stuff (export).
><br>recreate the database with the new characterset.
><br>import into new database.
><br>there is no other way.
><br>all the best
><br>vijay
><p>In article <82lkp5$2t3$1_at_nnrp1.deja.com>,
><br> screwbai_at_my-deja.com wrote:
><br>> I have Oracle server with US7* characterset. Now I want to create
>a
><br>> database with WE8* characterset. Do I have to can I just create a
>new
><br>> user with a different characterset.
><br>>
><br>> Sent via Deja.com http://www.deja.com/
><br>> Before you buy.
><br>>
><p>Sent via Deja.com http://www.deja.com/
><br>Before you buy.</blockquote>
></html>
>
>
--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Dec 09 1999 - 10:48:00 CST
 |
 |