SQL> SELECT SUBSTR(comp_id,1,15) comp_id,
status,
SUBSTR(version,1,10) version,
SUBSTR(comp_name,1,30) comp_name
FROM dba_registry ORDER BY 1
2 3 4 5 6 ;
COMP_ID STATUS VERSION
------------------------------ ----------- ------------------------------
COMP_NAME
--------------------------------------------------------------------------------
CATALOG VALID 9.2.0.7.0
Oracle9i Catalog Views
CATPROC INVALID 9.2.0.7.0
Oracle9i Packages and Types
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
SQL> exec DBMS_REGISTRY_SYS.VALIDATE_CATPROC;
PL/SQL procedure successfully completed.
SQL>SELECT SUBSTR(comp_id,1,15) comp_id,
status,
SUBSTR(version,1,10) version,
SUBSTR(comp_name,1,30) comp_name
FROM dba_registry ORDER BY 1
2 3 4 5 6 ;
COMP_ID STATUS VERSION
------------------------------ ----------- ------------------------------
COMP_NAME
--------------------------------------------------------------------------------
CATALOG VALID 9.2.0.7.0
Oracle9i Catalog Views
CATPROC VALID 9.2.0.7.0
Oracle9i Packages and Types
status,
SUBSTR(version,1,10) version,
SUBSTR(comp_name,1,30) comp_name
FROM dba_registry ORDER BY 1
2 3 4 5 6 ;
COMP_ID STATUS VERSION
------------------------------ ----------- ------------------------------
COMP_NAME
--------------------------------------------------------------------------------
CATALOG VALID 9.2.0.7.0
Oracle9i Catalog Views
CATPROC INVALID 9.2.0.7.0
Oracle9i Packages and Types
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
SQL> exec DBMS_REGISTRY_SYS.VALIDATE_CATPROC;
PL/SQL procedure successfully completed.
SQL>SELECT SUBSTR(comp_id,1,15) comp_id,
status,
SUBSTR(version,1,10) version,
SUBSTR(comp_name,1,30) comp_name
FROM dba_registry ORDER BY 1
2 3 4 5 6 ;
COMP_ID STATUS VERSION
------------------------------ ----------- ------------------------------
COMP_NAME
--------------------------------------------------------------------------------
CATALOG VALID 9.2.0.7.0
Oracle9i Catalog Views
CATPROC VALID 9.2.0.7.0
Oracle9i Packages and Types
