Home > Uncategorized > Oracle: impdp raises ORA-39083: Object type PROCOBJ failed to create with error: ORA-01843: not a valid month

Oracle: impdp raises ORA-39083: Object type PROCOBJ failed to create with error: ORA-01843: not a valid month

Problem description:

You are importing a data pump dumpfile and impdp raises the following error(s) when trying to create a job or schedule:

ORA-39083: Object TYPE PROCOBJ failed TO CREATE WITH error:
ORA-01843: NOT a valid MONTH
Failing SQL IS:
BEGIN
... dbms_scheduler commands ...
COMMIT;
END;

Cause:

The exporting data pump session used different NLS-settings than your currently importing one.

DBMS_SCHEDULER invokes your current NLS-settings when creating jobs/schedules. For instance, if your environment variable NLS_LANG was set to AMERICAN_AMERICA.WE8ISO8859P1 for your export, you should use the same setting during import. Otherwise creating scheduler jobs/schedules will raise above mentioned error messages.

Problem resolution:

You should use equivalent NLS_LANG settings in your environment when performing expdp and impdp. This will workaround the issue.

Categories: Uncategorized Tags:
  1. Marat
    July 11th, 2012 at 05:59 | #1

    I faced the same problem when i tried to use impdp over network link. NLS_LANG on both machines are the same.
    export | grep NLS
    declare -x NLS_DATE_FORMAT=”DD.MM.RR HH24:MI:SS”
    declare -x NLS_LANG=”AMERICAN_CIS.CL8ISO8859P5″
    But still get the error.
    –source base
    uname -a
    SunOS 5.10 Generic_118833-03 sun4u sparc SUNW,Sun-Fire-V490

    Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 – 64bi
    PL/SQL Release 10.2.0.2.0 – Production
    CORE 10.2.0.2.0 Production
    TNS for Solaris: Version 10.2.0.2.0 – Production
    NLSRTL Version 10.2.0.2.0 – Production

    —target base
    uname -a
    Linux 2.6.18-274.12.1.el5 #1 SMP Tue Nov 8 21:37:35 EST 2011 x86_64 x86_64 x86_64 GNU/Linux

    Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bi
    PL/SQL Release 10.2.0.3.0 – Production
    CORE 10.2.0.3.0 Production
    TNS for Linux: Version 10.2.0.3.0 – Production
    NLSRTL Version 10.2.0.3.0 – Production

    Any suggestions?

  2. Marat
    July 12th, 2012 at 12:58 | #2

    It works without errors, only then i did
    unset NLS_LANG

    • Matthias Pölzinger
      July 16th, 2012 at 12:02 | #3

      Hi Marat,

      thanks for your update.

      In my case I had to use expdp/impdp due to the limitations when transferring data over network link. The experience I made there was to double check the NLS settings on both sides as impdp reacts very sensitive on exported job information ;-)

      Best regards,
      Matthias

  1. No trackbacks yet.

Connect with Facebook