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