On 12 juin, 20:44, sybra..._at_hccnet.nl wrote:
> On Tue, 12 Jun 2007 09:47:04 -0700, News <Contact_..._at_hotmail.com>
> wrote:
>
>
>
>
>
> >On 12 juin, 17:20, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> >> On Jun 12, 3:48 am, News <Contact_..._at_hotmail.com> wrote:
>
> >> The only sure way to fix this is to recreate your tables with proper
> >> DEFAULT declarations:
>
> >> CREATE TABLE HR.T (D DATE DEFAULT to_date('0001-01-01','YYYY-MM-
> >> DD') NULL);
>
> >Thanks ! but ..
> >it's not my database !! I'm trying to clone Oracle Applications HR
> >module database.
>
> >The Tables are created this way by Oracle !!!!!!
>
> >and the problem remains : why altering nls-date-format works in
> >session level and not in system level in ini.ora ?
>
> Which problem? Something which is working as designed?
you mean nls-date-format in ini.ora is designed so .. to have no
effect ?
Received on Tue Jun 12 2007 - 14:12:06 CDT
