NLS_DATE_LANGUAGE...

Hello,
My system (w2k) is all english except for the "Input Locales" (keyboard) wich is French Canadian, why the following date is in french??

SQL> select to_char(to_date('02-02-02'),'dd-mon-yy') from dual;

TO_CHAR(T

As you can see the month is written fév instead of feb as would prefeer...

The thing is resolve if i use the ALTER SESSION SET NLS_DATE_LANGUAGE='AMERICAN', but i can't figure who to change it for a sqlloader session, is the only way is to set it via environement variable? I would like to change it permanetly, or at lest for on SCHEMA in particular, is it possible?

Here my NLSs parameters:

nls_calendar                         string
nls_comp                             string
nls_currency                         string
nls_date_format                      string
nls_date_language                    string
nls_dual_currency                    string
nls_iso_currency                     string
nls_language                         string      AMERICAN
nls_length_semantics                 string      BYTE
nls_nchar_conv_excp                  string      FALSE
nls_numeric_characters               string
nls_sort                             string
nls_territory                        string      AMERICA
nls_time_format                      string
nls_timestamp_format                 string
nls_timestamp_tz_format              string
nls_time_tz_format                   string

Thank, Received on Sun Apr 27 2003 - 08:47:33 CEST