Re: import 8i -> 9i

I don't think it's the problem, because both NLS_LANG (on both servers) are the same!!
And when I import the user in the same database (exp in 8i, and imp in 8i), I don't have this error!!!

Thanks.

"Peter van Rijn" <pgm.van.rijnRM_at_THIShccnet.nl> a écrit dans le message news: ap8jh6$ac9$1_at_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 - 06:52:09 CDT