DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, April 3, 2018

How to check invalid objects in Run & Patch Edition in R12.2 


To determine the Run/Patch edition in R12.2

set linesize 1024
col OLD for a10
col run for a20
col patch for a30
select apps.ad_zd.get_edition('OLD') "OLD",
apps.ad_zd.get_edition('RUN') "RUN",
apps.ad_zd.get_edition('PATCH') "PATCH"
from dual;

OLD        RUN                  PATCH
---------- -------------------- ------------------------------
           ORA$BASE             V_20180322_1648

Check invalid objects in Run Edition

SQL> select count(*) from dba_objects where status='INVALID';

  COUNT(*)
----------
       273

Check invalid objects in Patch Edition

ALTER SESSION SET EDITION = Patch_Edition_Name; (got from 1st query)

SQL> ALTER SESSION SET EDITION = V_20180322_1648;

Session altered.

SQL> select count(*) from dba_objects where status='INVALID';

  COUNT(*)
----------
       274

SQL>


No comments: