Turns out to be nls_teritory not set..
It's now sorted.
Thanks for the pointers.....
M.
<sybrandb_at_yahoo.com> wrote in message
news:1145889015.050484.32300_at_t31g2000cwb.googlegroups.com...
> No, it doesn't. If you don't set anything you'll get Windows specific
> defaults.
> Just run
> select * from nls_session_parameters
> /
> in sqlplus from the client and verify them with the servers settings.
>
> I found out when I ran into a case of
> create table blablad(timestamp date default '31-12-00')
> This assumed the default dateformat was dd-mm-yy. It was on the client.
> It wasn't on the server.
> Boy, I had fun. My import failed completely.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
Received on Tue Apr 25 2006 - 07:25:02 CDT
