Re: Database character set change

Here's how you should change the characterset(basically, this is taken directly from Oracle's documentation):

1. Shutdown Immediate:
2. Take a cold full backup
3. startup mount:
4. alter system enable restricted session;
5. alter system set job_queue_processes=0;
6. alter database open;
7. alter database character set <new_character_set_name>;
8. shutdown immediate
9. startup

HTH,
Pete's

Phivos <phivos_at_NO.mpriki.photonics.ntua.gr.SPAM> wrote in message news:<MPG.15f35f1365c7f17a989cb6_at_news.ntua.gr>...
> Στις Sun, 26 Aug 2001 13:45:46 +0300, avm_at_trais.com.ua - aka Anatoly
> Moskovsky, έγραψε...
>
>
> >
> > SB> Directly updating the dictionary invalidates any support contract.
> > SB> As you are, however, running a desupported version, in your case
> > SB> that probably doesn't make much difference.
> > SB> Just a warning for anyone wanting to apply the above advice on a
> > SB> supported version: don't do it. There are procedures for it, and
> > SB> they work.
> >
> > It would be very interesting for me (and I hope for all ) if you describe
> > those procedures or point at the place in the documentation where they are
> > described.
> > Thanks
>
>
> It would be very interesting and lots of trouble-saver...
>
>
> PS: Please note that I am talking for a *non-strict superset* charset
> conversion, i.e. WE8ISO8859P1 -> EL8ISO8859P7.
Received on Mon Aug 27 2001 - 07:30:18 CDT