Dump Pump Import Error - PROCACT_SCHEMA - identifier 'DBMS_AQADM' must be declared
Hello experts,
we are performing an export on Oracle 12.1.0.2 and are importing into Oracle 19c.
This errors can only be reproduced when exporting on Oracle 12.1 (not on 11.2, 12.2 or 19c).
The errors is depending on the export dump file and occurs on all mentioned version on import, if an "erroneous" export dump file was created when exporting on Oracle 12.1.
But this does not happen on all Oracle 12.1 users and not every time!
Logfile from Data Pump import into Oracle 19c:
24-AUG-21 04:59:41.118: W-1 Startup took 1 seconds 24-AUG-21 04:59:43.774: W-1 Master table "SYSTEM"."IMP_20210824_045932_782" successfully loaded/unloaded 24-AUG-21 04:59:45.559: Starting "SYSTEM"."IMP_20210824_045932_782": 24-AUG-21 04:59:45.700: W-1 Processing object type SCHEMA_EXPORT/USER 24-AUG-21 04:59:46.856: W-1 Completed 1 USER objects in 1 seconds 24-AUG-21 04:59:46.856: W-1 Processing object type SCHEMA_EXPORT/SYSTEM_GRANT 24-AUG-21 04:59:47.590: W-1 Completed 10 SYSTEM_GRANT objects in 0 seconds 24-AUG-21 04:59:47.590: W-1 Processing object type SCHEMA_EXPORT/ROLE_GRANT 24-AUG-21 04:59:48.231: W-1 Completed 4 ROLE_GRANT objects in 0 seconds 24-AUG-21 04:59:48.231: W-1 Processing object type SCHEMA_EXPORT/DEFAULT_ROLE 24-AUG-21 04:59:48.981: W-1 Completed 1 DEFAULT_ROLE objects in 0 seconds 24-AUG-21 04:59:48.981: