Re: import 8i -> 9i

From: Peter van Rijn <pgm.van.rijnRM_at_THIShccnet.nl>
Date: Thu, 24 Oct 2002 12:57:19 +0200
Message-ID: <ap8jh6$ac9$1@news.hccnet.nl>

It must be your NLS_LANG environment variable. If it's not set it will default to AMERICAN_AMERICA, meaning it will use the default DD-MON-YY date format. Set it to FRENCH_FRANCE (I assume) and it will work even when you don't explicitly set NLS_DATE_FORMAT.

hth,
Peter

"Epicentre Team B Annecy" <carmanet_at_epicentre.fr> schreef in bericht news:ap8ip4$t6v$1_at_wanadoo.fr...
> Hi!
>
> I exported a user under Oracle8i (on a Win2K), and tried to import it
> under Oracle9i (on a Linux RedHat 7.2 server); although NLS_DATE_FORMAT
> (and all others NLS_ parameters!) has the same value in the 2
environments,
> I've a ORA-01843 error:
>
> IMP-00017: following statement failed with ORACLE error 1843:
> " "" ALTER TABLE ""B_NOME"" MODIFY (""VER_EFFET_DEBUT"" DEFAULT
> '01/01/1995' )"""
> IMP-00003: ORACLE error 1843 encountered
> ORA-01843: not a valid month
>
> Then, I re-tried the same import on Oracle9i, after entering, on Linux:
> " export NLS_DATE_FORMAT='DD/MM/RR' "
> And it worked!!! No error in the log file?!!
>
> Any idea?
> Thanks
>
> Regards,
>
> Celine.
>
>
>
>
Received on Thu Oct 24 2002 - 05:57:19 CDT