Re: Character set when exporting

From: Michael Pelzelmeyer <mikepelz_at_netway.at>
Date: 1998/02/14
Message-ID: <34E5A826.49CE@netway.at>#1/1

Hi,
I think your problem is that you ran the export via cron. If a script is started via cron .profile is NOT executed, hence the NLS_LANG setting is missing. You can check this out via a small shell script that is started via cron.

---

#!/usr/bin/ksh
echo $NLS_LANG >/tmp/langsetting

---

Check the contents of the langsetting file.

HTH
Michael

Margaret Burwell wrote:
>
> I have an Oracle 7.3 database on a Sun server running SunOS 5.5.1.
> The database was created with WE8PC850 as the character set. The .profile
> for the account includes the line
>
> NLS_LANG=american_america.we8pc850 ; export NLS_LANG
>
> My overnight export which is run using cron contains the
> following:
>
> Connected to: Oracle7 Server Release 7.3.3.0.0 - Production Release
> With the distributed, replication, parallel query and Spatial Data options
> PL/SQL Release 2.3.3.0.0 - Production
> Export done in US7ASCII character set
>
> Can anyone enlighten me on why the characterset is changed?
>
> Marg
  Received on Sat Feb 14 1998 - 00:00:00 CST