My Oracle Support Banner

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

Last updated on FEBRUARY 23, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

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

Starting "<LOGIN_SCHEMA>"."<JOB_NAME>":
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 := '<SCHEMA_NAME>'; HIST_REC(i).PASSWORD := '<PASSWORD_VALUE>'; HIST_REC(i).PASSWD_DATE := '11-DEC-09'; i := i+1; HIST_REC(i).USERNAME := '<SCHEMA_NAME>'; HIST_REC(i).PASSWORD := '<PASSWORD_VALUE>';
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.

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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.