Friday, May 28, 2021

Recompile Invalid objects in PDB database (Multitenant)

 RECOMPILE INVALID OBJECTS IN PDB (PLUGGABLE DATABASE)

conn / as sysdba
alter session set container=PDB$SEED;

show con_name

select open_mode from v$database;

alter session set "_oracle_script"=TRUE;

alter pluggable database pdb$seed close immediate instances=all;

select open_mode from v$database;

alter pluggable database pdb$seed OPEN READ WRITE;

show con_name;

select open_mode from v$database;

@?/rdbms/admin/utlrp.sql

col COMP_NAME for a35;
col COMP_ID for a10;
set linesize 120;
select comp_id, comp_name, version, status from dba_registry;
select count(*) from dba_objects where status='INVALID';

col OBJECT_NAME for a30;

select object_name, object_type, owner from dba_objects where status='INVALID' order by owner;
select owner, object_type, count(*) from dba_objects where status = 'INVALID' group by owner, object_type;

alter pluggable database pdb$seed close immediate instances=all;

alter pluggable database pdb$seed OPEN READ ONLY;

show con_name;

select open_mode from v$database;

alter session set "_oracle_script"=FALSE;

No comments: