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

Last updated on APRIL 17, 2023

Applies to:

Goal

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.

Solution

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