DBMS_AQ_SYS_IMP_INTERNAL invalid after converting 19.13 noncdb to 21.x pdb
We are migrating from 19.13 to 21c. The 19.13 DB is a noncdb. The 21c is a CDB.
We are using the following steps:
1) CREATE PLUGGABLE DATABASE FROM DB@clone_link
2) catctl.pl
3) noncdb_to_pdb.sql
4) utlrp.sql
Everything is fine after the migration, except for DBMS_AQ_SYS_IMP_INTERNAL:
alter package DBMS_AQ_SYS_IMP_INTERNAL compile body;
Warning: Package Body altered with compilation errors.
show errors
Errors for PACKAGE BODY DBMS_AQ_SYS_IMP_INTERNAL:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2344/4 PL/SQL: SQL Statement ignored
2353/37 PL/SQL: ORA-00932: inconsistent datatypes: expected NUMBER got
TIMESTAMP WITH TIME ZONE
DBMS_AQ_SYS_IMP_INTERNAL is VALID in the source database.