Wednesday, July 06, 2022

That's syntax for ya! Here's the "new" way to recompile invalid objects on and CDB / PDB in Oracle Database Server 19c (and above), a little trickier than just @utlrp.sql huh! ...

cd $ORACLE_HOME/rdbms/admin 
$ORACLE_HOME/perl/bin/perl catcon.pl --n 1 --e --b utlrp --d '''.''' utlrp.sql

At least querying them back is easier:
select * from dba_invalid_objects;

For reference:

This is a post from Gareth's blog at http://garethroberts.blogspot.com

No comments: