Database Utilities (MOSC)

MOSC Banner

Dump Pump Import Error - PROCACT_SCHEMA - identifier 'DBMS_AQADM' must be declared

edited Aug 25, 2021 6:18AM in Database Utilities (MOSC) 3 comments

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center