Re: Changing Character Set on a 7.3.2.x Database.

"PhaE" <voosterbaan_at_desyde.nl> wrote in message news:Wzx78.23$R96.953_at_psinet-eu-nl...
> Hi there,
>
> One of our clients has Oracle 7.3.2.x, and wants me to change the
> character-set.
> He thinks it's easy as 1-2-3, but I don't believe it :o)
> I searched on Metalink, but all the articles are about Oracle 8.x and
above.
> Anyone has an idea how to do this on Oracle 7?
> I read something about doing an update on SYS.PROPS$, but it did not say
if
> this would work on 7.x
> And after that an import of the previously created export-file.
> But I'm afraid that any special characters could be misformed or corrupt
or
> whatever after that.
>
> Hope you can help!
>
> Greetings,
> Victor Oosterbaan.
>
>
>

Updating sys.props$ is desupported, as is -of course- for many years (1998) 7.3.2
The official method is to recreate the database with the correct characterset.

so
export the old database
recreate the database
make sure the environment variable/registry key NLS_LANG has the correct characterset
import.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address