Database Software

Hi,

I'm migrating production database with data pump, and I'm getting errors "ORA-01843: not a valid month". If I run failed sql with sqlplus it works all right ! Details are below. Please help I someone have idea how to resolve this (without changing production objects - there is too much of failed objects), Thanks in advance !

Regards !

Failing sql is:
CREATE TABLE "POT_DDV"."KIR" ("ID" CHAR(10 BYTE) DEFAULT ' ' NOT NULL ENABLE, "TIP_R" CHAR(4 BYTE) DEFAULT ' ' NOT NULL ENABLE, "TIP_R1" CHAR(1 BYTE) DEFAULT ' ' NOT NULL ENABLE, "D_KNJ" DATE DEFAULT TO_DATE ('1899-12-30' ,'YYYY-MM-DD') NOT NULL ENABLE, "RACUN" CHAR(15 BYTE) DEFAULT ' ' NOT NULL ENABLE, "D_RAC" DATE DEFAULT TO_DATE ('1899-12-30' ,'YYYY-MM-DD') NOT NULL ENABLE, "KUPEC" CHAR(10 BYTE) DEFAU
ORA-39083: Object type TABLE failed to create with error:
ORA-01843: not a valid month

expdp is done on source databas running on Sun Solaris with command:

NLS_LANG=AMERICAN_AMERICA.EE8ISO8859P2; export NLS_LANG
$ORACLE_HOME/bin/expdp "'/ as sysdba'" full=Y directory=expimpdp PARALLEL=4 dumpfile=expdp%U.dmp logfile=expdp.log JOB_NAME=expdpfull


impdp is done on target databas running on OE linux with command:

NLS_LANG=AMERICAN_AMERICA.EE8ISO8859P2; export NLS_LANG
impdp "'/ as sysdba'" directory=expimp dumpfile=expdp%U.dmp logfile=impdp.log SCHEMAS=POT_DDV, <other users/schemas, ...>

NLS parameters on source: 1 select * from v$nls_parameters
2*

PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET EE8ISO8859P2
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET UTF8
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE



NLS parameters on target:
SQL> select * from v$nls_parameters
2 ;

PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET EE8ISO8859P2
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET UTF8
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE