For once I support Sybrand's statement :-) (no offense Sy-dude)
Anyone claiming things like 'but on page x on this book it states ...'
without even trying it out makes
me smile :-)
Heck it was even possible on Oracle7 by updating the props$ table and yes
Sy - it was not supported but
you probably know that :-)
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:i2otkukd3uphh5uai4rktuau26af34f47k_at_4ax.com...
> On Mon, 05 Aug 2002 15:21:43 -0400, JC <jeffc_at_sympatico.ca> wrote:
>
> >Sybrand Bakker wrote:
> >
> >> Not true, for 8.0 and higher. You CAN change the characterset provided
> >> the new characterset is an exact superset of the old characterset.
> >> Apparently UTF8 isn't a superset of CL8WIN1251.
> >> In that case the export/import route is the only solution and no
> >> 'forcing of the database' is possible.
> >
> >In the Oracle 8i Certified Professional book it states the opposite on
page
> >635. Now this book has been proven to be wrong before. I went into the
> >exam thinking that the NLS values couldn't be changed. I could be wrong
> >and if you have any sources that prove you can please let me know.
>
> How about the manual called 'Sql reference' under 'Alter database'
> If that's wrong we would have known in the meantime, don't you think.
> Anyway, I've changed databases' charactersets several times using
> alter database.
> There is a note up on Metalink with the exact details
> (job_queue_processes must be 0, aq_tm_processes too)
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Mon Aug 05 2002 - 15:38:55 CDT
