My Oracle Support Banner

How To Validate Invalid Package "SYS.DBMS_AQADM_SYSCALLS" (Doc ID 2483854.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Followed the below DOC ID to validate  this package "SYS.DBMS_AQADM_SYSCALLS"

How to validate invalid package SYS.DBMS_AQADM_SYS (Doc ID 2208934.1)

The package DBMS_AQADM_SYS packages created with errors and its invalid state. 

Suggested below solution for  DBMS_AQADM_SYS invalid . 

SQL>@$ORACLE_HOME/rdbms/admin/dbmsaqds.plb --> creates package
SQL>@$ORACLE_HOME/rdbms/admin/prvtaqds.plb -- >creates package body

But customer still having " DBMS_AQADM_SYSCALLS invalid and not able to create datapump objects.



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

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