DataPump Import (IMPDP) Fails With Errors ORA-39083 ORA-6550 PLS-00103 On Object Type PASSWORD_HISTORY (Doc ID 1053162.1)

Last updated on NOVEMBER 28, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 28-NOV-2012***

Symptoms

When importing a dump file with IMPDP the following errors are raised:

Starting "BACKUPUSERR1"."dp_21426_12":
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY
ORA-39083: Object type PASSWORD_HISTORY failed to create with error:
ORA-06550: line 1, column 26976:
PLS-00103: Encountered the symbol "DECLARE"
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 := 'STAGESET3R1'; HIST_REC(i).PASSWORD := 'C42005196432786D'; HIST_REC(i).PASSWD_DATE := '11-DEC-09'; i := i+1; HIST_REC(i).USERNAME := 'STAGESET3R1'; HIST_REC(i).PASSWORD := '58E0C666771D9EE6';
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Checking the USER_HISTORY$ contents of the originating database reveals that this table contains a lot of rows.

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