Send your questions to appsdbauniverse@gmail.com

Sunday, February 21, 2016

How to make Invalid object from dba_registry table to Valid


SQL> select comp_id,comp_name,status from dba_registry where status='INVALID';

COMP_ID    COMP_NAME                    STATUS
---------- ---------------------------- --------
SDO        Spatial                      INVALID
ORDIM      Oracle Multimedia            INVALID
EXF        Oracle Expression Filter     INVALID


SQL> exec dbms_registry.valid('SDO');

PL/SQL procedure successfully completed.

SQL> exec dbms_registry.valid('ORDIM');

PL/SQL procedure successfully completed.

SQL> exec dbms_registry.valid('EXF');

PL/SQL procedure successfully completed.

SQL> select comp_id,comp_name,status from dba_registry where status='INVALID';

no rows selected

========================================================================

No comments:

Post a Comment