help with date format !!!! urgent

From: News <Contact_404_at_hotmail.com>
Date: Tue, 12 Jun 2007 01:48:50 -0700
Message-ID: <1181638130.830319.239310@z28g2000prd.googlegroups.com>

in ini.ora:
NLS_DATE_FORMAT = YYYY-MM-DD SQL> show parameter nls_date_format

nls_date_format                      string      YYYY-MM-DD

SQL> CREATE TABLE HR.T (D DATE DEFAULT '0001-01-01'     NULL);

ORA-01847: day of month must be between 1 and last day of month

SQL> alter session set nls_date_format="YYYY-MM-DD";

Session altered.

SQL> CREATE TABLE HR.T (D DATE DEFAULT '0001-01-01' NULL); Table created.

changing nls_date_format has effect in session and not in system level.

Please help ! i cannot import full database because of this problem.

SQL> select * from v$version;

BANNER

---

Oracle9i Release 9.2.0.1.0 - 64bit Production PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production Received on Tue Jun 12 2007 - 03:48:50 CDT