1) exec dbms_registry.valid('CATPROC');
2) @utlrp.sql
3) SHUTDOWN IMEMDIATE
4) STARTUP UPGRADE
5) @catalog.sql
6) @catproc.sql
7) @utlrp.sql
8) SHUTDOWN IMMEDIATE
2) @utlrp.sql
3) SHUTDOWN IMEMDIATE
4) STARTUP UPGRADE
5) @catalog.sql
6) @catproc.sql
7) @utlrp.sql
8) SHUTDOWN IMMEDIATE
9) STARTUP
10) exec dbms_registry.valid('CATPROC');
OR
10)
set serverout on feedback on
BEGIN
dbms_registry.update_schema_list('CATPROC', dbms_registry.schema_list_t('SYSTEM', 'OUTLN', 'DBSNMP'));
dbms_registry.loaded('CATPROC');
dbms_registry_sys.validate_catproc;
dbms_registry_sys.validate_catalog;
END;
/
dbms_registry.update_schema_list('CATPROC', dbms_registry.schema_list_t('SYSTEM', 'OUTLN', 'DBSNMP'));
dbms_registry.loaded('CATPROC');
dbms_registry_sys.validate_catproc;
dbms_registry_sys.validate_catalog;
END;
/
No comments:
Post a Comment