IMPDP Fails with ORA-39083 and ORA-06502 for PASSWORD_HISTORY
(Doc ID 1551778.1)
Last updated on MARCH 01, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterInformation 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 := '<VALUE>';
HIST_REC(i).PASSWD_DATE := '<DATE>';
i := i+1; HIST_REC(i).USERNAME := '...';
HIST_REC(i).PASSWORD := '21\
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |