Ones I talked to Oracle support about this and They told me not to do that.
I is very much possible that you would not be able to start up the database.
But if you realy want to do this you have to reinstall the whole database.
mas Kyte <tkyte_at_us.oracle.com> wrote in message
news:s7nv4s82gp9flf6nlg0kt7fa1c374itrl9_at_4ax.com...
> 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 <a
href="http://www.deja.com/">http://www.deja.com/</a>
> ><br>> Before you buy.
> ><br>>
> ><p>Sent via Deja.com <a
href="http://www.deja.com/">http://www.deja.com/</a>
> ><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 - 23:18:39 CST
