Re: Problems with character set after Export/Import

Answers embedded

Hth,

Sybrand Bakker, Oracle DBA

"Christoph Ernst" <christoph.xy.ernst_at_t-online.de> wrote in message news:96ele7$9dq$07$1_at_news.t-online.com...
> Hi there,
>
> i tried several times to export/import a database from Oracle
 7.2.3(Solaris)
> to 8.1.6(Solaris/NT).
> After the import, my special characters are gone, although i set the
> character set with
> SETENV NLS_LANG ...
> My questions:
> 1.) How can i find out the character set used in my database? (Can't find
> that in V$PARAMETER)

select * from nls_database_parameter
or
select * from sys.props$

> 2.) How do i have to set the character set at import and export?

by using NLS_LANG
if you don't do that your export will be automatically in US7ASCII, of which you will be notified immediately after the sign-on banner. Running export with log=<any file> is always useful, because this info will scroll off the screen
> 3.) How do i have to set the character set on NT? (Environment?)

in HKEY\local_machine\software\oracle
>
> Thx,
> Christoph
>
>
>
Received on Wed Feb 14 2001 - 13:34:18 CST