DataPump Import (IMPDP) Fails With Errors ORA-39083 ORA-01830

(Doc ID 1915829.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

 

import finished with following errors :

ORA-39083: Object type PASSWORD_HISTORY failed to create with error:
ORA-01830: date format picture ends before converting entire input string
Failing sql is:
DECLARE SUBTYPE HIST_RECORD IS SYS.DBMS_PSWMG_IMPORT.ARRAYOFHISTORYRECORDS; HIST_REC HIST_RECORD; i number := 0; BEGIN i := i+1; HIST_REC(i).USERNAME := 'MDBCAMPAIGN'; HIST_REC(i).PASSWORD := '3C49762B6CEBA43C'; HIST_REC(i).PASSWD_DATE := '10-FEB-2011 12:41:39'; i := i+1; HIST_REC(i).USERNAME := 'MDBCAMPAIGN'; HIST_REC(i).PASSWORD := 'F96ADB0F911
ORA-39083: Object type PASSWORD_HISTORY failed to create with error:
ORA-01830: date format picture ends before converting entire input string
Failing sql is:
DECLARE SUBTYPE HIST_RECORD IS SYS.DBMS_PSWMG_IMPORT.ARRAYOFHISTORYRECORDS; HIST_REC HIST_RECORD; i number := 0; BEGIN i := i+1; HIST_REC(i).USERNAME := 'MDBCUSTOMER'; HIST_REC(i).PASSWORD := '837D31E2DBABA2DA'; HIST_REC(i).PASSWD_DATE := '10-FEB-2011 12:43:53'; i := i+1; HIST_REC(i).USERNAME := 'MDBCUSTOMER'; HIST_REC(i).PASSWORD := '2F5A3E54D04
ORA-39083: Object type PASSWORD_HISTORY failed to create with error:
ORA-01830: date format picture ends before converting entire input string

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms