Re: import 8i -> 9i

From: M Hashim <m.a.n.hashim_at_sympatico.ca>
Date: Fri, 25 Oct 2002 19:50:22 -0700
Message-ID: <FJku9.14308$Kf.1669566@news20.bellglobal.com>

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:65egru8tt3o5aulrf904l8o6m1j5bga8f7_at_4ax.com...
> On Thu, 24 Oct 2002 13:52:09 +0200, "Epicentre Team B Annecy"
> <carmanet_at_epicentre.fr> wrote:
>
> >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!!!
>
> No, you are wrong. You don't have this problem in 8i because in that
> case the table exists.
> But the real problem is anyway not export / import but some developer
> not using default to_date('01-01-1995','dd-mm-yyyy')
> as that was obviously too much trouble.
> Either change NLS_LANG, or pre-create the table.

> Beat the developer with a whip in both cases.

It's called corporeal punishment...Administer Corporeal Punishment. Write yourself a "Trigger" to deliver the punishment! :)

>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Fri Oct 25 2002 - 21:50:22 CDT