IMPDP Fails with ORA-39083 and ORA-06502 for PASSWORD_HISTORY (Doc ID 1551778.1)

Last updated on MAY 08, 2013

Applies to:

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

Symptoms

Migrating Oracle database release 10.2.0.4.0 to 11.2.0.3.0 using Datapump export and import.

Getting errors ORA-39083 and ORA-06502 when importing into Oracle release 11.2.0.3.0:


Import: Release 11.2.0.3.0 - Production on Wed May 1 22:02:17 2013
...
Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY

ORA-39083: Object type PASSWORD_HISTORY failed to create with error:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small

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 := '....'; HIST_REC(i).PASSWORD := '33C07EAE499EF651';
HIST_REC(i).PASSWD_DATE := '18-OCT-2011 04:44:17';
i := i+1;  HIST_REC(i).USERNAME := '...';
HIST_REC(i).PASSWORD := '21\




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